Can you please tell me the names of the artists who don't have any exhibitions?
SELECT name FROM artist WHERE artist_id NOT IN  ( SELECT artist_id FROM exhibition ) 
artists who don't have any exhibitions refers to NOT IN operation with a subquery selecting artist_id from exhibition;