Table: metro_conference_teams
Columns: institution
nickname
location
founded
type
enrollment
joined
left

Question: Name the number of left for cardinals
SQL: SELECT COUNT("left") FROM metro_conference_teams WHERE "nickname" = 'Cardinals'

Question: Name the school that is private
SQL: SELECT "institution" FROM metro_conference_teams WHERE "type" = 'Private'

Question: Name the location that was founded 1798
SQL: SELECT "location" FROM metro_conference_teams WHERE "founded" = 1798

Question: Name the nickname that was founded 1798
SQL: SELECT "nickname" FROM metro_conference_teams WHERE "founded" = 1798