假設創作者的姓名為唯一：
(SELECT name
FROM Product AS P, Author AS A
WHERE catalog = ‘Book’ AND P.pNo = A.pNo)
INTERSECT
(SELECT name
FROM Product AS P, Author AS A
WHERE catalog = ‘CD’ AND P.pNo = A.pNo);

SELECT mId, name
FROM Member
WHERE (mId IN (SELECT B.mId
                            FROM Browse AS B, Product AS P
                            WHERE pName = ‘系統分析理論與實務’AND P.pNo = B.pNo))
                AND
                (mId NOT IN (SELECT transMid
                                        FROM Product AS P, Record AS R, Transaction AS T
                                        WHERE pName = ‘系統分析理論與實務’
                                        AND P.pNo = R.pNo AND R.tNo = T.tNo));

1.Q4：找出所有瀏覽過或購買過「系統分析理論與實務」的會員之會員編號和會員姓名。
SELECT mId, name
FROM Member
WHERE (mId IN (SELECT B.mId
                             FROM Browse AS B, Product AS P
                             WHERE pName =‘系統分析理論與實務’AND P.pNo
                                                       = B.pNo))
                OR
                (mId IN (SELECT transMid
                FROM Product AS P, Record AS R, Transaction AS T
                WHERE pName = ‘系統分析理論與實務’ AND P.pNo = R.pNo AND
                               R.tNo = T.tNo));

2.Q7：找出「黃三益」所瀏覽過的商品裡，哪些有真正被他購買。
SELECT pNo
FROM Browse AS B, Member AS M, Record AS R, Transaction AS T
WHERE M.name = ‘黃三益’ AND M.mId = B.mId AND
               B.pNo = R.pNo AND R.tNo = T.tNo AND transMid = M.mId ;

SELECT P.pNo, pName, name
FROM Product AS P LEFT OUTER JOIN Author AS A ON P.pNo=A.pNo;

SELECT M.mId, M.name , cartTime
FROM Member AS M , Order AS O
WHERE O.mId = M.mId
GROUP BY M.mId, M.name, cartTime
HAVING COUNT(pNo) > 3;

UPDATE Record
SET salePrice = salePrice*0.9
WHERE tNo IN
                (SELECT tNo
                FROM Transaction, Member
                WHERE address LIKE ‘%台北市%’AND mId = transMid);

1. CREATE VIEW Product_amount (catalog, catalogAmount)
AS (SELECT catalog, COUNT (pNo)
        FROM Product
        GROUP BY catalog);
2. 因為此VIEW 包含彙總函數 (COUNT)，所以會造成修改的不明確, 故此VIEW 不能被修改。
3. DROP VIEW Product_amount;