Using Microsoft Access. SQL entries booking (hotelNo, guestNo, dateFrom, dateTo,
ID: 3708753 • Letter: U
Question
Using Microsoft Access. SQL entries
booking (hotelNo, guestNo, dateFrom, dateTo, roomNo, rateBooked)
employee (empID, empFirst, empLast, empDateHired, empEmail, managerID, hotelNo)
guest (guestNo, guestFirst, guestLast, guestStreet, guestCity, guestState, guestPhone, guestEmail)
hotel (hotelNo, hotelName, hotelCity, hotelPhone)
room (roomNo, hotelNo, type, standardprice)
--------------------------------------------------------------------------------------------------
Query 8: List each employee’s first name, last name, their hotelNo, their manager’s first name and their manager’s last name.
Query 9: which guests have yahoo email accounts?
Query 10: which hotel (by name) has the most expensive room ?
Query11: which guests (by name) have not booked rooms in hotel 1?
Explanation / Answer
SELECT empFirst, empLast,managerID, hotelNo FROM employee;
SELECT * FROM guest WHERE guestEmail LIKE "%yahoo%";
SELECT MAX(standardprice) FROM room INNER JOIN hotel ON hotel.hotelNo = room.hotelNo;
SELECT guestFirst FROM guest INNER JOIN booking ON guest.guestNo = booking.guestNo AND roomNo != 1;
**Comment for any further queries.