Question: For each information request below, formulate a single SQL query to produce the required information. 1. What is the average shipping cost on a sale?

For each information request below, formulate a single SQL query to produce the required information.

1. What is the average shipping cost on a sale? (Name the column AverageShipping). Also use the Round function to two decimal places for currency, i.e. round ( .. , 2) .

2.What is the average shipping cost on sales made in the month of June? Name the column AverageShipping. Also use the Round function to two decimal places for currency, i.e. round ( ... , 2) .

3. How many products does Redcat have from Manufacturer 154? (Name the column NumberProducts.)

4. What is the largest dollar amount (SalePrice times Quantity) for a sale item that was ever made? Name it LargestItemSale.

5. Which products have the highest list price, and what is that price? (Hint: Use a subquery) Only show product name and the price.

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 Databases Questions!

SQL I5 3351003 - 2022 Sumr 5.35 Correlated subqueries 3 These are queries That use the full Red Cat Database as shown in Figure 3.1. To do these queries you cannot use The SimpliedSales database. You...

Can someone really help me this is the second time I have to submit my question because the answers I been given are wrong, I keep getting Error's from the answers given here. SQL-IS3351003-2022Sumr...

These are simple queries that use the full Red Cat Database as shown in Figure 3.1. To do these queries you cannot use the SimplifiedSales database. You must use the full Red Cat tables of Customer,...

These are queries that use the full Red Cat Database as shown in Figure 3.1. To do these queries you cannot use the SimplifiedSales database. You must use the full Red Cat tables of Customer, Sale,...

7 These are queries that use the full Red Cit Database as shown in Figure 3.1. To do these queries you cannot use the SimplifiedSales database. You mi use the full Red Cat tables of Customer, Sale,...

I need help with this SQL I keep getting error the information is not found. These are queries that use the full Red Cat Database as shown in Figure 3.1. To do these queries you cannot use the...

For each information request below, formulate a single SQL query to produce the required information. In each case, you should display only the columns requested. Be sure that your queries do not...

These are queries that use the full Red Cat Database as shown in Figure 3.1. Do not use the SimplifiedSales database. You must use the full Red Cat tables of Customer, Sale, SaleItem, Product,...

6 . 2 s Join Queries on full Redcat DB ( MS SQL Server ) For each information request below, formulate a single SQL query to produce the required information. In each case, you should display only...

Grades Announcements Let f(x) = 37 If g(x) is the graph of f(z) shifted down 5 units and right 6 units, write a formula for g(z) g(x)= Enter as sqrt(x) 1pt 01299

What do you think happened to inflation expectations between 2007 and 2009 and why?

When shares of stock are purchased from unidentifiable _____ lots, the following method must be used to account for the sale a. First-in, first-out b. Last-in, last-out c. Weighted average d....

a. 5. Consider the following two zero coupon bonds with face value of $1000: Annual return for 2-year bond is 1.5% b. Annual return for 3-year bond is 2% Assume the pure expectations theory for the...