For this assignment use the Apparel database that you downloaded in class today.

$1)$ Create a query that will display the company name and phone number for all phone

numbers in the area code $714.$ Sort the output in ascending order by phone numbers. $($Call

the query Phone$).$

$2)$ Display the company name, state and number of orders for all companies in California

that had between $100$ and $500$ orders. Sort by the number of orders in descending order.

$($Call the query Orders$).$

$3)$ Write a query that prompts the user to enter a state and then display all the companies in

that state with total sales over $$1,000,000.$ Display the company name, state and sales.

Sort by sales in descending order. Do not show decimal places for the total sales and

name the column for the sales as Total Sales. Format the sales column to show the

currency. $($Call the query prompt$).$

$4)$ Create one query that will display the total sales of all companies located in Hawaii and

the total sales of all companies located in Oregon. In addition to total sales, show the

smallest and largest sale in each state. $($Call the query total$).$

$5)$ Create a query that will display the number of companies located in each zip code.

Display the zip code and the number of companies. Sort by zip code. $($Call the query zip$).$

$6)$ Create a query that will display the average number of orders for each city within each

state. Display the State, City and average number of orders $($up to one place of decimal$).$

$($Call the query avg$).$