I need the commands for this design using Mysql Workbench. Please don't write me the answer in a notebook!

1. What was the occupancy rate for each hotel in Virginia last night?

2. What was last night's occupancy rate for each room type in Virginia hotels?

3. What were the occupancy rates of Virginia hotels for July?

4. what were average room revenues for different hotels during the Christmas season?

Address Hotel PK Customer ID Name ZipCode PK ZipCode PK HotellD Street District State HotelName ZipCode Room PK Number PK Date, Room Number CustomerID Number Occupants Number Days Daily_Price Daily Taxes HotellD TypelD Size Number_of_Beds Bed Type Max_Occupants Refrigerator Kitchenette HotelID TypelD Date HotellD RoomStatus RoomType Revenue PK RoomNumber, Date PK TypelD PK TransactionID Status Type TypelD Date HotellD Customer ID Revenue Description