160523SQL simple four kinds of query statements

--Find products with a product price greater than $15 and a purchase of more than 1 items at a time.
--1.
Select A.product_id,a.name from
(SELECT * FROM Products p where p.price>15) a INNER join
(SELECT * from purchases PR where pr.quantity>1) b on
a.product_id=b.product_id
--2.
Select P.product_id,p.name from Products p INNER JOIN purchases PR
On p.product_id=pr.product_id and p.price>15 and pr.quantity>1;
--3.
Select P.product_id,p.name from Products p where p.price>15 and p.product_id in
(select pr.product_id from purchases PR where pr.quantity>1);
--4.
Select p.product_id from Products p where p.price>15
Intersect
Select pr.product_id from purchases PR where pr.quantity>1

160523SQL simple four kinds of query statements