SELECT count(DISTINCT roomtype) FROM room
How many different types of rooms are there?
SELECT count ( DISTINCT roomtype ) FROM room
select count ( distinct roomtype ) from room
How many different types of rooms are there ?