Page 1 of 1
Which of the following is the correct SQL to obtain the total sales dollars by employee and product? Select employee, pr
Posted: Fri May 20, 2022 3:38 pm
by answerhappygod
- Which Of The Following Is The Correct Sql To Obtain The Total Sales Dollars By Employee And Product Select Employee Pr 1 (54.21 KiB) Viewed 29 times
Which of the following is the correct SQL to obtain the total sales dollars by employee and product? Select employee, product, sum(salesdollars) From sales Having department - 2 Group by employee, product: Select employee, product, sum(salesdollars) From sales Where department = 2 Group by employee, product; Select employee, product, sum(salesdollars) From sales Having department = 2 Group by employee; Select employee, product, sum(salesdollars) From sales Where department = 2 Group by employee;