Hello! Can you provide me with a list of all of the artist names?
select name from artist
Excellent!  Can you filter this list to show only the names of artists above the age of 46?
select name from artist where age > 46
Great!  Can you tell me how many of these artists above age 46 joined after 1990?
select count ( * ) from artist where age > 46 and year_join > 1990