queries.sql

来自「Advanced SQL For this exercise, we will」· SQL 代码 · 共 18 行

--(
	--SELECT LibID,Fname,Join_date
	--FROM MEMBER4
	--WHERE (MEMBER4.LibID LIKE 'A&%B%' ESCAPE '&' or MEMBER4.LibID LIKE 'A&&B%' ESCAPE '&') AND Join_date < '1997-11-30'
--);

--(
	--SELECT DISTINCT Name,ISBN,TITLE4.CallNumber
	--FROM TITLE4,ORDERED4,PURCHASE_ORDER4
	--WHERE (TITLE4.CallNumber = ORDERED4.CallNumber AND ORDERED4.PoNum = PURCHASE_ORDER4.PoNum) AND PURCHASE_ORDER4.qty > 10 

--);

(
	SELECT DISTINCT PoNum
	FROM PURCHASE_ORDER4
	WHERE PURCHASE_ORDER4.qty > 10
);