SELECT count(*) FROM artist WHERE age  >  46 AND year_join  >  1990
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
select count ( * ) from artist where age > value and year_join > value
Count the number of artists who are older than 46 and joined after 1990 .