Database: performance_attendance
Question: Show different locations and the number of performances at each location.
SQL:
SELECT LOCATION ,  COUNT(*) FROM performance GROUP BY LOCATION