Question: Use subquery & CTEwhat is the year with the biggest total sales for the bikes. (original query) SELECT P.ProductID, P.Name, SUM(S.LineTotal) AS TotalSales FROM Sales.SalesOrderDetail

Use subquery & CTEwhat is the year with the biggest total sales for the bikes.

(original query)

SELECT P.ProductID, P.Name, SUM(S.LineTotal) AS TotalSales

FROM Sales.SalesOrderDetail S

JOIN Production.Product P ON S.ProductID = P.ProductID

WHERE P.ProductNumber LIKE 'BK%'

GROUP BY P.ProductID, P.Name,

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!

Q:

use Adventure Works Database Run each query and save the notebook with the results before submitting it. All the questions below are related to AdventureWorks database. make sure your notebook is...

Q:

Can someone assist me with how to create these queries? STEP 4: Analyze Sales Growth by U.S. Region Management has asked you to analyze the percentage growth rate in sales from prior year to current...

Q:

1 As Dr. Chen has emphasized since Module 3, to write SQL code for a given query question ("List.... ") , the FIRST thing that needs to be figured out correctly is ____________________. 1. What are...

Q:

please help USE the HR2550 Database bellow , and write a single script -- 6. Display the department id and department name for all departments whose location id is equal to the location id where the...

Q:

Division (DID, dname, managerID) Employee (empID, name, salary, DID ) Project (PID, pname, budget, DID ) Workon (PID, EmpID , hours) Formulate the following queries. You must copy each query question...

Q:

You need to write your SQL query statements for each question and put them all in a single.SQL (or ,bxt file) and upload them to the assigned folder on D2L. Here is the ERD diagram of the datacode....

Q:

Question: What needs to be answered: Table Data: Hi if you could please list the SQL queries needed to complete 1-21 that would be amazing please and thank! Ive included screenshots of all the...

Q:

Write the queries necessary to obtain the required information. Make sure all columns you return have descriptive column headings. You must show the result of the query. For example, if the query is:...

Q:

Please help with these sql queries drop table workon; drop table employee; drop table project; drop table division; create table division (did integer, dname varchar (25), managerID integer,...

Q:

Problem: The Queen Anne Curiosity Shop sells both antiques and current-production household items that complement or are useful with the antiques. For example, the store sells antique dining room...

Q:

Two friends, Al and Jo, have a combined mass of 168 kg. At an ice skating rink, they stand close together on skates, at rest and facing each other, with a compressed spring between them. The spring...

Q:

A company borrows $ 5 0 0 , 0 0 0 at 6 % annual interest, to be repaid over 1 0 years in equal annual payments. What is the annual loan payment the company must make? $ 5 5 , 3 2 0 $ 6 7 , 1 5 5 $ 6...

Q:

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

Q:

=+3 What is the employers responsibility if something happens to its employees while on foreign assignment?

Q:

=+4 What is the responsibility of IHR in both of these circumstances? How could

Q:

=+1 Are WLB issues different in newly developing countries from what is experienced in developed countries? Why or why not? Is there a trade-off between WLB and career ambition?