Guest User

Untitled

a guest
Nov 21st, 2018
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.96 KB | None | 0 0
  1. Room 201, 2016-12-11
  2.  
  3. +--------------+--------+---------+--------------+
  4. | booking_date | nights | room_no | arrival_time |
  5. +--------------+--------+---------+--------------+
  6. | 2016-12-01 | 2 | 201 | 17:00 |
  7. | 2016-12-02 | 2 | 301 | 20:00 |
  8. | 2016-12-03 | 5 | 101 | 16:00 |
  9. | 2016-12-03 | 4 | 201 | 18:00 |
  10. | 2016-12-04 | 1 | 301 | 15:00 |
  11. | 2016-12-05 | 5 | 301 | 14:00 |
  12. | 2016-12-07 | 4 | 201 | 20:00 |
  13. | 2016-12-08 | 2 | 101 | 18:00 |
  14. | 2016-12-10 | 5 | 101 | 23:00 |
  15. | 2016-12-12 | 1 | 301 | 12:00 |
  16. | 2016-12-15 | 3 | 101 | 19:00 |
  17. +--------------+--------+---------+--------------+
  18.  
  19. SELECT booking_date, nights, room_no, arrival_time
  20. FROM booking
  21. WHERE booking_date BETWEEN '2016-12-01' AND '2016-12-31'
  22. AND room_type_requested LIKE '%Single%'
  23. ORDER BY booking_date;
Add Comment
Please, Sign In to add comment