Database: institution_sports
Question: What are different types of affiliations of institutions and the corresponding number of institutions?
SQL:
SELECT Affiliation ,  COUNT(*) FROM institution GROUP BY Affiliation