Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Quantitative Methods For Business

Authors: Donald Waters

5th Edition

273739476, 978-0273739470

More Books

Students also viewed these General Management questions

Question

What is a shareholders agreement?

Answered: 1 week ago

Question

2. Give ample praise for good answers.

Answered: 1 week ago