Answered step by step
Verified Expert Solution
Question
1 Approved Answer
3) Write a query that prompts the user to enter a state and then display all the companies in that state with total sales
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).
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started