How many artists are above age 46 and joined after 1990?
SELECT count(*) FROM artist WHERE age  >  46 AND year_join  >  1990
artists above age 46 refers to age > 46; joined after 1990 refers to year_join > 1990; count of such artists refers to SELECT count(*)