How many rooms have not had any reservation yet?
SELECT count(*) FROM rooms WHERE roomid NOT IN (SELECT DISTINCT room FROM reservations)
rooms that have not had any reservation refers to rooms not present in the reservations table; counting these rooms requires COUNT(*) function;