What is the most commonly booked room type for each hotel in London?
What will be an ideal response?
SELECT MAX(X)
FROM ( SELECT type, COUNT(type) AS X
FROM Booking b, Hotel h, Room r
WHERE r.roomNo = b.roomNo AND b.hotelNo = h.hotelNo AND
city = ‘London’
GROUP BY type);
Computer Science & Information Technology
You might also like to view...
When using load-balancing mode, one server is assigned as the active server that provides DHCP services to clients while the other server is placed in standby mode.
Answer the following statement true (T) or false (F)
Computer Science & Information Technology
What are seven essential items that the analyst should include in performing a Web site traffic analysis?
What will be an ideal response?
Computer Science & Information Technology