Show different teams in eliminations and the number of eliminations from each team.
CREATE TABLE elimination (Team VARCHAR)
SELECT Team, COUNT(*) FROM elimination GROUP BY Team
### Context: CREATE TABLE elimination (Team VARCHAR) ### Question: Show different teams in eliminations and the number of eliminations from each team. ### Answer: SELECT Team, COUNT(*) FROM elimination GROUP BY Team