SELECT count(DISTINCT roomtype) FROM room
Find the number of distinct room types available.
SELECT count ( DISTINCT roomtype ) FROM room
select count ( distinct roomtype ) from room
Find the number of distinct room types available .