Question: On the Sales table the following SQL statement below is executed. SELECT SalesPersonID, SalesRegion, SUM ( SalesVolume ) AS 'Total Sales' from Sales GROUP BY
On the Sales table the following SQL statement below is executed.
SELECT SalesPersonID, SalesRegion, SUMSalesVolume AS 'Total Sales' from Sales GROUP BY CUBESalesPersonIDSalesRegion
How many rows are there in the result of the query?
Question options:
tableSalesPersonIDSalesRegion,State,Month,SalesVolumeSWest,Califomia, January,SWest,Oregon, January,SEast,New York, January,SEast,Maine, January,SWest,Califomia, February,SWest,Oregon, February,SEast,New York, February,SEast,Maine, February,SWest,Califomia, March,SWest,Oregon, March,SEast,New York, March,SWest,Califomia, January,SWest,Oregon, January,SEast,New York, January,SWest,Califomia, February,SWest,Oregon, February,SEast,New York, February,SEast,Maine, February,SWest,Califomia, March,SWest,Oregon, March,SEast,New York, March,SEast,Maine, March,
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
