Which of the following is the correct SQL to obtain the total sales dollars by employee and product? Select employee, pr
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Which of the following is the correct SQL to obtain the total sales dollars by employee and product? Select employee, pr
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;
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!