List the number of rooms in each hotel in London.
What will be an ideal response?
SELECT hotelNo, COUNT(roomNo) AS count FROM Room r, Hotel h
WHERE r.hotelNo = h.hotelNo AND city = ‘London’
GROUP BY hotelNo;
Computer Science & Information Technology
You might also like to view...
You can use the ____ method to remove any spaces that appear before and after the data in the variable.
A. Trim B. Left C. Right D. RmPad
Computer Science & Information Technology
The ____________________ feature in Outlook allows you to preview an attachment you receive in an email message.
Fill in the blank(s) with the appropriate word(s).
Computer Science & Information Technology