Show all artist names.
select name from artist
Show all exhibitions.
select * from exhibition
Count exhibitions for each artist.
select count(*) from exhibition as t1 join artist as t2 on t1.artist_id = t2.artist_id group by t1.artist_id
Show all artist names and the number of exhibitions for each artist.
select t2.name, count(*) from exhibition as t1 join artist as t2 on t1.artist_id = t2.artist_id group by t1.artist_id