1. Find product id for the products that have been ordered more than 300 units in total. List ProductID of such products

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

1. Find product id for the products that have been ordered more than 300 units in total. List ProductID of such products

Post by answerhappygod »

1. Find product id for the products that have been ordered morethan 300 units in total. List ProductID of such products togetherwith the total ordered quantity of each product. Sort your resultaccording to the ascending order of the second column.
2. Consider only the orders handled by employees with IDs3, 5, or 7. Among those orders, find customers who have placed morethan 2 orders. In the result, list the CustomerID of such customerstogether with the OrderDate of their latest order. (Hint: youshould use the Max() function to find the latest OrderDate.)
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Top
Post Reply

Return to “Archived Questions & Answers”