Find the ids of all the rooms that have been reserved before.
select distinct room from reservations
Which rooms have not had any reservation yet?
select * from rooms where roomid not in (select distinct room from reservations)
How many are there?
select count(*) from rooms where roomid not in (select distinct room from reservations)