Table: usa_south_athletics
Columns: institution
location
nickname
founded
type
enrollment
joined

Question: When was the University founded that joined in 1978?
SQL: SELECT MAX("founded") FROM usa_south_athletics WHERE "joined" = 1978

Question: When was Piedmont College founded?
SQL: SELECT MAX("founded") FROM usa_south_athletics WHERE "institution" = 'Piedmont College'

Question: When were the Avenging Angels founded?
SQL: SELECT MAX("founded") FROM usa_south_athletics WHERE "nickname" = 'Avenging Angels'

Question: What institution joined in 1988?
SQL: SELECT "institution" FROM usa_south_athletics WHERE "joined" = 1988