Which artists have an age above 46?
select * from artist where age > 46
Which artists have an age above 46 and joined after 1990?
select * from artist where age > 46 and year_join > 1990
How many are there?
select count(*) from artist where age > 46 and year_join > 1990