IM USING TERMINAL ON MACOS

Part $1$ Creation of database, using the database, creation of tables, inserts of Part $2$: Create the following queries

Write a query fetching the customer's email address and full name.

Write a query fetching the hotel name and the entire address which is located

in Los Angeles California.

Write a query that fetches all the reservations whose check$-$in date is from

July $2$nd to December $23$rd$.$

Write a query that fetches all the reservations whose is staying $5$ days or

more and has more than $2$ guest.

Write a query that fetches how many reservations each hotel has.

Write a query that fetches the category and description of the room and its

daily rate, whose description contains king$-$sized bed.

Write a query that fetches the highest$-$priced room, lowest$-$priced room, and

the average price of the room.

Write a query that fetches all the rooms, and sort them from the highest to

lowest price rooms. Part $1$ Creation of database, using the database, creation of tables, inserts of

data, the screenshot that shows you are a customer and you made a

reservation,

SELECT $*$ FROM CUSTOMER; SELECT $*$ FROM RESERVATION;

SELECT $*$ FROM ROOM; SELECT $*$ FROM HOTEL;

All $8$ queries of part $2$

data, the screenshot that shows you are a customer and you made a

reservation,

SELECT $*$ FROM CUSTOMER; SELECT $*$ FROM RESERVATION;

SELECT $*$ FROM ROOM; SELECT $*$ FROM HOTEL;

All $8$ queries of part $2$