Show me all the rooms that cost more than 120.
select * from rooms where baseprice > 120
How many rooms?
select count(*) from rooms where baseprice > 120
Tell me how many rooms cost more than 120, for each different decor.
select decor, count(*) from rooms where baseprice > 120 group by decor;