The Real Estate management has asked you to provide some insights into number of properties listed in each state. Write one (1) MySQL query statement that returns the number properties listed in each state.

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. Your query should return a table in the following format.

..