Output columns:
1.	p.*
Source tables:
1.	part AS p
2.	supply as s
Join conditions:
1.	p.pnum = s.pnum
Problem Conditions: supplied by supplier S2 or S3.
1.	S.snum = ‘S2’ or s.snum = ‘S3’
Viewing Orders:
1.	ORDEY BY p.weight DESC


SELECT DISTINCT p.*
FROM part AS p INNER JOIN supply as s ON (p.pnum = s.pnum)
WHERE s.snum = 'S2' or s.snum = 'S3'
ORDER BY p.weight DESC;

SELECT DISTINCT p.*
FROM part AS p INNER JOIN supply as s ON (p.pnum = s.pnum)
WHERE s.snum = 'S2' or s.snum = 'S3'
ORDER BY p.weight DESC
LIMIT 4;

SELECT DISTINCT p.*
FROM part AS p INNER JOIN supply as s ON (p.pnum = s.pnum)
WHERE s.snum = 'S2' or s.snum = 'S3'
ORDER BY p.weight DESC
LIMIT 2,3;