SELECT count(*) FROM rooms WHERE roomid NOT IN (SELECT DISTINCT room FROM reservations)
How many rooms have not had any reservation yet?
SELECT count ( * ) FROM rooms WHERE roomid NOT IN ( SELECT DISTINCT room FROM reservations )
select count ( * ) from rooms where roomid not in ( select distinct room from reservations )
How many rooms have not had any reservation yet ?