Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Room 201, 2016-12-11
- +--------------+--------+---------+--------------+
- | booking_date | nights | room_no | arrival_time |
- +--------------+--------+---------+--------------+
- | 2016-12-01 | 2 | 201 | 17:00 |
- | 2016-12-02 | 2 | 301 | 20:00 |
- | 2016-12-03 | 5 | 101 | 16:00 |
- | 2016-12-03 | 4 | 201 | 18:00 |
- | 2016-12-04 | 1 | 301 | 15:00 |
- | 2016-12-05 | 5 | 301 | 14:00 |
- | 2016-12-07 | 4 | 201 | 20:00 |
- | 2016-12-08 | 2 | 101 | 18:00 |
- | 2016-12-10 | 5 | 101 | 23:00 |
- | 2016-12-12 | 1 | 301 | 12:00 |
- | 2016-12-15 | 3 | 101 | 19:00 |
- +--------------+--------+---------+--------------+
- SELECT booking_date, nights, room_no, arrival_time
- FROM booking
- WHERE booking_date BETWEEN '2016-12-01' AND '2016-12-31'
- AND room_type_requested LIKE '%Single%'
- ORDER BY booking_date;
Add Comment
Please, Sign In to add comment