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

Transcribed Image Text:

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). 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).