Show me the names of all the artworks.
select name from artwork
Show me their types as well.
select name, type from artwork
What is the number of artworks for each type?
select type, count(*) from artwork group by type
Which of these types is the most common?
select type from artwork group by type order by count(*) desc limit 1