Database: conference
Question: Show all conference names and the number of times each conference has.
SQL:
SELECT conference_name ,  count(*) FROM conference GROUP BY conference_name