(1)
SELECT * FROM Goods
WHERE color IN('red', 'yellow', 'blue')
AND price BETWEEN 100 AND 300

(2)
SELECT * FROM Goods
WHERE NOT color IS NULL AND NOT color="" AND price>100

(3)
SELECT sname, sum(qty) FROM Supplier su, Stock st
WHERE su.sno=st.sno
GROUP BY su.sno
HAVING sum(qty)>=5

(4)
SELECT g.gno, gname, sum(qty) FROM Goods g, Stock s
WHERE g.gno=s.gno
GROUP BY g.gno
ORDER BY sum(qty) DESC

(5)
SELECT g.gno, gname, sum(qty)*price FROM Goods g, Stock s
WHERE g.gno=s.gno
GROUP BY g.gno
HAVING sum(qyt)*price>=500
ORDER BY sum(qty)*price DESC