Table: coast_conferences
Columns: institution
location
founded
type
enrollment
nickname
joined
left
current_conference

Question: Which conference has the nickname Chargers?
SQL: SELECT "current_conference" FROM coast_conferences WHERE "nickname" = 'Chargers'

Question: Which conference has the nickname Lions?
SQL: SELECT "current_conference" FROM coast_conferences WHERE "nickname" = 'Lions'

Question: What joined year does Dropped Athletics have?
SQL: SELECT MAX("joined") FROM coast_conferences WHERE "current_conference" = 'Dropped athletics'

Question: What is the latest founded year?
SQL: SELECT MAX("founded") FROM coast_conferences