Please write aview to list the payment statement with the city name, the total number of hotelrooms in the city with a cheap room (price less than $70), and the total cost if all cheap rooms are bookedfor all the hotels in the city. The output columns should be city, count, cost, sorted by the total costfrom high to low. [MariaDB [dreamhome]>+▬▬▬▬▬▬-+———·| hotelno | hotelname+ch01ch02dc01| fb01|fb02|+-5 rows in set (0.001 sec)select * from Hotel;| Omni Shoreham | London| Phoenix Park| Latham| London || Berlin || Grosvenor| Watergate-+501 |fb01601 |fb01701 | ch02701 | fb01801 | ch02901 | dc011991 | ch911001dc011001 |fb021181 | che11101dc011101 | fb02———[MariaDB [dreamhome]> select * from Room;+▬▬▬▬▬▬-| roomno | hotelno——————➖➖➖➖➖➖+| price |-+---| single | 19.00 || double | 29.00 || single | 10.00 |family | 39.00 || double | 15.00 || single | 18.00 || single | 29.99 |double 30.00 |type-+| city 1——-+-12 rows in set (0.001 sec)| London || Paris▬▬▬▬▬▬▬▬▬▬▬| single | 58.00| family | 59.99 || family | 35.00| double | 86.00 |-+

The topic was about a SQL View that lists the payment statement with the city name, the total number…

Answered: Please write a view to list the payment…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Please write a
view to list the payment statement with the city name, the total number of hotel
rooms in the city with a cheap room (price less than $70), and the total cost if all cheap rooms are booked
for all the hotels in the city. The output columns should be city, count, cost, sorted by the total cost
from high to low.

[MariaDB [dreamhome]>
+▬▬▬▬▬▬
-+———·
| hotelno | hotelname
+
ch01
ch02
dc01
| fb01
|fb02
|
+-
5 rows in set (0.001 sec)
select * from Hotel;
| Omni Shoreham | London
| Phoenix Park
| Latham
| London |
| Berlin |
| Grosvenor
| Watergate
-+
501 |
fb01
601 |
fb01
701 | ch02
701 | fb01
801 | ch02
901 | dc01
1991 | ch91
1001
dc01
1001 |
fb02
1181 | che1
1101
dc01
1101 | fb02
———
[MariaDB [dreamhome]> select * from Room;
+▬▬▬▬▬▬-
| roomno | hotelno
———
———
➖➖➖➖➖➖+
| price |
-+---
| single | 19.00 |
| double | 29.00 |
| single | 10.00 |
family | 39.00 |
| double | 15.00 |
| single | 18.00 |
| single | 29.99 |
double 30.00 |
type
-+
| city 1
——-
+-
12 rows in set (0.001 sec)
| London |
| Paris
▬▬▬▬▬▬▬▬▬▬▬
| single | 58.00
| family | 59.99 |
| family | 35.00
| double | 86.00 |
-+

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions