Write MySQL queries for the following questions (screenshots show correct results): The database is called "Rentals" You can use any name for a table example.

Using a subquery return all reservations that have more than the average number of people

Now add the the firstname and lastname to the previous query

Using a subquery return all guests with reservations

Create stored procedure that returns all personnel

Create view that displays all properties with reservations

reservationid people | 503 513 3522 15 525 16 5530 14 531 7537 10 12 20 15 1 1 1 1 1234567 - 4 5 6 7