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.

$1.$ Provide a count of unsold properties by branch $($use BranchCity$).$ Sort the results by

count in descending order.

$2.$ List the average days on the market $($SaleDate $-$ ListingDate$)$ by branch $($use BranchCity$).$

Sort the list by average days in ascending order.

$3.$ List the branch ID$,$ agent ID$,$ sales goal, and total sales for active real estate agents who

did not meet their sales goal in $2022.$ Sort the list by branch ID and Employee ID$.$

$4.$ Provide the full name of property $2000$s owner, along with the full name of their agent.

$5.$ List all active employees $($include employee ID$,$ first name, and last name$)$ at branch $14$

and their skills if they are paralegals.

$6.$ List the names of the property features that Jennifer Kelly is interested in$.$ Sort the list

by feature name is ascending order.

$7.$ Provide the average sale price for a $3$ bedroom, $2\mathrm{.}5$ bathroom property in cities that

begin with B$.$ Sort the results by city in ascending order.

$8.$ List the average percent difference between the listing and sale prices by branch $($use

BranchCity$).$ Sort the list by percent difference in descending order. $($Hint: percent

difference $=($SalePrice $-$ ListingPrice$)/$ListingPrice$)$