Question
Write SQL codes 12. Report: orderid, orderdate, productname, categoryname, price (all orders where product price is less then 15) (inner join) 13. Report: Show me
Write SQL codes
12. Report: orderid, orderdate, productname, categoryname, price (all orders where product price is less then 15) (inner join)
13. Report: Show me products that have not been ordered yet, Productname,orderid (null) - (left join)
14. Report: Show me the top 10 most ordered Products (join / group by ) - sum of qty
15. Report: Show me the top 10 most Revenue generating Products (join / group by) - Revenue=qty*price
16. Report: Show me the top 10 customers by revenue (join / group by)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Quantitative Methods For Business
Authors: Donald Waters
5th Edition
273739476, 978-0273739470
