SELECT count(*) FROM rooms WHERE roomid NOT IN (SELECT DISTINCT room FROM reservations)
Find the number of rooms that do not have any reservation.
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 )
Find the number of rooms that do not have any reservation .