SCHEMA:
CREATE TABLE room (roomtype VARCHAR)
USER:
How many different types of rooms are there?

QUERY:
SELECT COUNT(DISTINCT roomtype) FROM room