Question: 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

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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

The following transactions occurred in relation to the widget inventory of Hackack Ltd during the month of July. Calculate the COGS and gross profit for July, assuming a perpetual inventory system is...

The current AUD/USD spot rate is 0.7212. Today's date is 7th August, 2020. 6, 7 and 8 month AUD/USD swap rates are -35, -49 and -59 points, respectively. Determine the FX swap rate to 26th March,...

You are required to write a Python program that will manage character (heroes and villain) information. Character (hero and villain) information will be stored in a text file that will be read in...

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 7 1 4 ....

For this assignment use the Sport Apparel Retailers 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...

This is c++ program. Please do not reuse any program on Chegg. Thank you!! COSC 2436 521 Program Set #1 Total Points: 30 Three problems must be implemented for full credit. Each section will state...

Help with zip files, thanks ! Introduction Below is a sort of partial class diagram for our PV project. We'll attempt to write some basic 00 Python programming logics that will be expanded down the...

Help with zip files for source codes... MyClass.py and pd4.py MDS FILE TEST RESULTS WITH NOCT Introduction Below is a "sort of" partial class diagram for our PV project. We'll attempt to write some...

Complete the following programs using Python. 1 The cost of renting a room at a hotel is, say $100.00 per night. For special occasions, such as a wedding or conference, the hotel offers a special...

Comments are required. Include screenshot of your work A Real Estate Agency needs Management System that records the details about their offers: houses and apartments In this project, you will be...

Compare the following reward schemes: - Performance- related pay - Competency- related pay - Contribution- related pay - Skill-based pay Your comparison should be built on the following points: 1....

Culver Company provides the following selected information related to its defined benefit pension plan for 2020. Pension asset/liability (January 1) $25,800 Cr. Accumulated benefit obligation...

How Excel can help you find the future value of your investments? One of the most commonly applied concepts in finance is the determination of the value of an investment in future. Future value...

Nicole had a 5-year-old son, Karson, who had been diagnosed by his pediatric psychiatrist with ADHD. The physician tried multiple different medications and dosages with varying results to help...

Dr. Alimam is studying infants' ability to distinguish shapes. He shows an infant a shape until the infant loses interest in the shape, and then he shows the infant a different shape. If the infant...

For the spirometer activities, record experimental respiratory volumes as determined in the laboratory. (Corrected values and FEV1, are for the recording spirometer only.) Average TV: ml Corrected...

There are a number of theories of the term structure of interest rates including the unbiased expectations hypothesis, preferred habitat hypothesis, and market segmentation hypothesis. Discuss the...

A hardware store stocks eight types of pipes, one of which is stainless steel (SS). Assuming there are at least 20 pipes of each type, how many ways can a total inventory of 20 pipes be distributed...

Determine if the overhead allocated to the product relates to a single plantwide overhead rate method, multiple production department factory overhead rate method, or activity-based costing...

44. The number of customers entering a store on a given day is Poisson distributed with mean = 10. The amount of money spent by a customer is uniformly distributed over (0, 100). Find the mean and...

48. Suppose that we want to predict the value of a random variable X by using one of the predictors Y1, . . . , Yn, each of which satisfies E[Yi |X] = X. Show that the predictor Yi that minimizes...

45. An individual traveling on the real line is trying to reach the origin. However, the larger the desired step, the greater is the variance in the result of that step. Specifically, whenever the...