Find the number of rooms that do not have any reservation.
create table rooms (roomid varchar, room varchar, PRIMARY KEY (roomid)); create table reservations (roomid varchar, room varchar, PRIMARY KEY (roomid))
select count(*) from rooms where not roomid in (select distinct room from reservations)