1. ABC Real Estate provides their loyal vendors with a monthly newsletter, in which they provide statistics about the property sales for the States where the agency operates. Write one (1) MySQL query statement that returns the average sale price for properties that were 'under contract' in February 2022 for each property type where the agency operates. The result should be sorted from highest to lowest by average sale price.

House Type	Average Sale price
House
APartment
Unit
Townhouse
Land

2. The management of ABC Real Estate wants to know the details of the agent who sold property ID '25'. This can be done in two ways: I. Sub-Query II. Joins Write one (1) MySQL statement for each to achieve this. Both queries should return exactly the same result, and the result should be displayed in the following format.

Agent ID

Name

Age

Gender

They agency also wants to know the details of all the properties owned by the Vendor ID '22'. Write one (1) MySQL statement to list the properties owned by Vendor ID '22'. Your query should return a table in the following format.

Property ID

Property Suburb

Build Year