Question
Write SQL codes from w3schools 1- orderid, orderdate, productname, categoryname, price (all orders where product price is less then 15) (INNER JOIN) 2- The top
Write SQL codes from w3schools
1- orderid, orderdate, productname, categoryname, price (all orders where product price is less then 15) (INNER JOIN)
2- The top 10 products that have not been ordered yet, Productname,orderid (null) - (left join)
3- The top 10 most ordered Products (join / group by ) - sum of qty
4- The top 10 most Revenue generating Products (join / group by) - Revenue=qty*price
5- 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
Principles Of Database Systems With Internet And Java Applications
Authors: Greg Riccardi
1st Edition
020161247X, 978-0201612479
