Provide the SQL for the following data requests. Your SQL should be written as a single script

that can be pasted into MySQL and run without edits. Make sure you use the proper notation

for your comments $($see the practice solution for an example of the format$).$ There will be a $5\%$

deduction for scripts that cannot be pasted into MySQL and run without edits.

List the first name, last name, and full address for all active real estate agents.

Provide a count of unsold properties by branch $($use BranchID$).$ Sort the list by count in

descending order.

List the property ID and full address for all Florida and Georgia properties located on

Main Street. Sort the list by state and property ID in ascending order.

Provide the average listing price for a $2-$story property with $3$ bedrooms and $2\mathrm{.}5$

bathrooms.

List the ID$,$ first name, and last name for any customers both are both owners and

clients.

Provide a list of real estate agents $($use AgentID$)$ who have over $4$ million dollars in sales

for $2022.$

Provide a distinct list of bedrooms and bathrooms for properties less than $1500$ square

feet. Sort the list by the number of bedrooms and bathrooms.

Provide the average cost per square foot for properties in California, Michigan, and

Texas. Sort the results by cost in descending order. $($Hint: cost per square foot $=$

ListingPrice$/$SquareFeet$)$