- 8
- 8.   List all part colors.
SELECT DISTINCT
FROM
WHERE

SELECT DISTINCT COlOR
FROM PART;

SELECT DISTINCT COlOR
FROM PART
ORDER BY COLOR;

25.  Show all information of suppliers with a status of 
greater than five and supplies a part of weight greater than five.

SELECT DISTINCT SUPPLIER.*
FROM SUPPLIER, SUPPLY, PART
WHERE SUPPLIER.SNUM = SUPPLY.SNUM
AND SUPPLY.PNUM = PART.PNUM   -- join condition.
AND PART.WEIGHT > 5
AND SUPPLIER.STATUS > 5;

Q: Supplier names that supply both green and red part

-- Supplier names that supply both green part
SELECT DISTINCT SName
FROM SUPPLIER, SUPPLY, PART
WHERE SUPPLIER.SNum = SUPPLY.SNum
AND SUPPLY.PNUM = PART.PNUM
AND PART.Color = 'Green';

A: 
SELECT DISTINCT SName
FROM SUPPLIER, SUPPLY S1, SUPPLY S2, PART P1, PART P2
WHERE SUPPLIER.SNum = S1.SNum
AND SUPPLIER.SNum = S2.SNum
AND S1.PNUM = P1.PNUM
AND S2.PNUM = P2.PNUM
AND P1.Color = 'Green' 
AND P2.Color = 'Red';