SELECT College ,  COUNT(*) FROM submission GROUP BY College
SELECT College ,  COUNT(*) FROM submission GROUP BY College <table_name> : submission col : Submission_ID | Scores | Author | College row 1 : 1 | 72 | Steve Niehaus | Notre Dame row 2 : 2 | 79 | Sammy Green | Florida row 3 : 3 | 78 | Sherman Smith | Miami (OH) row 4 : 4 | 79 | Steve Raible | Georgia Tech row 5 : 5 | 82 | Jeff Lloyd | West Texas State row 6 : 6 | 89 | Rick Engles | Tulsa row 7 : 7 | 92 | Don Bitterlich | Temple row 8 : 8 | 93 | Steve Myer | New Mexico row 9 : 9 | 82 | Randy Johnson | Georgia row 10 : 10 | 83 | Andy Bolton | Fisk
col : College | COUNT(*) row 1 : Fisk | 1 row 2 : Florida | 1 row 3 : Georgia | 1 row 4 : Georgia Tech | 1 row 5 : Miami (OH) | 1 row 6 : New Mexico | 1 row 7 : Notre Dame | 1 row 8 : Temple | 1 row 9 : Tulsa | 1 row 10 : West Texas State | 1