Database: art_1
Question: How many works are there in each medium?
SQL:
SELECT count(*) ,  medium FROM paintings GROUP BY medium