Using various SQL commands that you have learned, perform the following SQL queries: 

●Need to CREATE all tables 

● INSERT all tuples of data After you have created all your tables and data, run SQL statements to perform the following: 

● DELETE one row of data from each table 

● UPDATE one row of data from each table 

● ALTER one table by adding a new attribute 

● Prepare SELECT statement to display: 

A. The total number of guests currently staying at the hotel. 

B. List the names of all the guests currently staying at the hotel. 

C. List the names of the staff that provide housekeeping services in the hotel. 

D. List the name of the guests along with the room number they have reserved and arrange them in alphabetical order. 

E. list the details of a reservation that was done on 01/03/2020 including the main guest's name, number of guests and room details . 

F. List the type of rooms the hotel has and how frequently they are booked. 

G. List details of all staff members that are not in a management position. 

H. which guest stayed longer in the hotel

Answer rating: 100% (QA)

Certainly here are the SQL commands to create tables insert data and perform the requested queries You can customize these queries based on your speci... View the full answer