Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select count(*) from room
- where not exists(
- select building_id, floor_num, room_num from room r
- join reservation re
- on(
- r.room_num = re.room_num and
- r.floor_num = re.floor_num and
- r.building_id = re.building_id
- )s
- group by room_num, floor_num
- where arrival_date<=? and departure_date>=?
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement