List all the rooms.
select * from rooms;
Count the number of rooms.
select count(*) from rooms;