Question
Find all reservations in room HBB that overlap by at least one day with any stay by customer with last name KNERIEN. Last last and
Find all reservations in room HBB that overlap by at least one day with any stay by customer with last name KNERIEN. Last last and first name along with checkin and checkout dates. Sort by check in date in chronological order.
TABLES:
Rooms: RoomId : a three-letter unique Id code of a room roomName : official name of the room beds : number of beds in the room bedType : type of the bed(s) in the room. All beds in each room are of the same type. maxOccupancy : maximum number of people allowed to stay in the room basePrice : base price (in US dollars) of one night of stay in the room. decor : decoration style of the room
Reservations Code : reservation code Room : the three-letter room code (see Rooms.RoomId) CheckIn : date of check-in/arrival CheckOut : date of check-out/departure Rate : actual nightly rate. Each night of stay on one reservation always costs the same amount, although rates may vary for the same room from one reservation to another LastName : last name of the person who made the reservation FirstName : first name of the person who made the reservation Adults : number of adults (18 and above) staying in the room. Each reservation must have at least one adult Kids : number of kids (ages 0-17) staying in the room.
Expected:
GROWNEY | MELVIN | 2010-07-22 | 2010-07-25 |
MABRA | MARGET | 2010-08-31 | 2010-09-09 |
LEDOUX | LENA | 2010-12-10 | 2010-12-14 |
COASTER | MERLE | 2010-12-14 | 2010-12-19 |
DECHELLIS | AARON | 2010-12-21 | 2010-12-22 |
BRAND | TROY | 2010-12-22 | 2010-12-23 |
PLEASE EXPLAIN:
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started