Question: write a query that will pivot the sales _ totals data so that there is a column for each of the 4 products containing the
write a query that will pivot the salestotals data so that there is a column for each of the products containing the total sales across all months of It is ok to include the productid values in your query, and the results should look as follows: totsaleslargegears, totsalessmallgears, totsalescrankshafts, totsalessprockets,
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
