Guest User

Untitled

a guest
May 25th, 2018
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.39 KB | None | 0 0
  1. Customer(ID, name, birthDate, city);
  2. Room(number, floor, beds, roomtype, price);
  3. Bookings(Customer, roomNumber, floor, checkInDate, checkOutDate);
  4.  
  5. select Customer from Bookings
  6. join Room on(Bookings.num = camera.roomNumber and Bookings.floor=
  7. Room.floor)
  8. where (Bookings.Customer, Bookings.floor) not in (select number, floor from
  9. Room where roomType != 'economic')
Add Comment
Please, Sign In to add comment