Count the number of artists who are older than 46 and joined after 1990.
SELECT count(*) FROM artist WHERE age  >  46 AND year_join  >  1990
artists older than 46 refers to age > 46; joined after 1990 refers to year_join > 1990; count the number refers to SELECT COUNT(*)