SELECT Team ,  COUNT(*) FROM elimination GROUP BY Team
How many eliminations did each team have?
SELECT Team , COUNT ( * ) FROM elimination GROUP BY Team
select team , count ( * ) from elimination group by team
How many eliminations did each team have ?