Database: conference
Question: For each conference name, how many times has it occurred?
SQL:
SELECT conference_name ,  count(*) FROM conference GROUP BY conference_name