Database: institution_sports
Question: How many institutions are there for each type of affiliation?
SQL:
SELECT Affiliation ,  COUNT(*) FROM institution GROUP BY Affiliation