I need the commands for this design using Mysql Workbench.

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.