Which of the following is the correct SQL to obtain the total sales dollars by employee and product? Select employee, pr

[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 28 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;