INNER JOIN PRACTICE IN DATA BASE, Exercises of Database Management Systems (DBMS)

Download INNER JOIN PRACTICE IN DATA BASE and more Exercises Database Management Systems (DBMS) in PDF only on Docsity!

from customer as c inner join orders as o on c.customer_id = o.customer_id group by o.customer_id order by COUNT(o.customer_id) desc Query 5 select c.customer_name, p.product_name from customer as c inner join orders as o on c.customer_id = o.customer_id inner join orderproduct as op on o.order_id = op.order_id inner join product as p on p.product_id = op.product_id Query 6 select c.customer_id, SUM(op.product_qty) from customer as c inner join orders as o on c.customer_id = o.customer_id inner join orderproduct as op on o.order_id = op .order_id group by c.customer_id Query 7 select c.customer_id, COUNT(o.order_id) from customer as c inner join orders as o on c.customer_id = o.customer_id group by c.customer_id Query 8 select o.order_id,p.product_name,p.product_price,op.product_qty from orders as o inner join orderproduct as op on o.order_id = op.order_id inner join product as p on op.product_id = p.product_id