Database: theme_gallery
Question: Count the number of artists who are older than 46 and joined after 1990.
SQL:
SELECT count(*) FROM artist WHERE age  >  46 AND year_join  >  1990