CREATE TABLE performance (LOCATION VARCHAR2)

Show different locations and the number of performances at each location.
SELECT LOCATION, COUNT(*) FROM performance GROUP BY LOCATION
SELECT "LOCATION", COUNT(*) FROM "performance" GROUP BY "LOCATION"