Using Microsoft Access. SQL entries booking (hotelNo, guestNo, dateFrom, dateTo,

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.

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.