習題解答 | new connection intro b解答
[Ch07] [D7-1]C@WFAY䤤wWL500ӫ~ؼ˼ƶWL2ӪܡAhCXsMʶRwWL500ӫ~ؼ˼ơCoMPQ20PC [D7-2]1.(SELECTmId,nameFROMMemberWHEREaddressLIKE%x_%ANDmIdNOTIN(SELECTintroducerFROMMember);5.(SELECTDISTINCTmId,nameFROM(MemberNATURALJOINBrowse)NATURALJOINProductWHEREpName=̪LMG)EXCEPT(SELECTDISTINCTmId,nameFROMMemberJOIN((TransactionNATURALJOINRecord)NATURALJOINProduct)ONmId=transMidWHEREpName=̪LMG); [D7-4]1.SELECTProduct.pNo,pName,unitPrice,COUNT(name)FROMProductLEFTOUTERJOINAuthorONProduct.pNo=Author.pNoGROUPBYProduct.p...
[ Ch 07 ]
[ D7-1 ]
C@WFAY䤤wWL 500 ӫ~ؼ˼ƶWL 2 ӪܡAhCXsMʶRwWL 500 ӫ~ؼ˼ơCoMP Q20 PC
[ D7-2 ]
1.( SELECT mId, name FROM Member WHERE address LIKE % x_ % AND mId NOT IN ( SELECT introducer FROM Member);
5. ( SELECT DISTINCT mId, name FROM (Member NATURAL JOIN Browse) NATURAL JOIN Product WHERE pName = ̪LMG ) EXCEPT ( SELECT DISTINCT mId, name FROM Member JOIN ((Transaction NATURAL JOIN Record) NATURAL JOIN Product) ON mId = transMid WHERE pName = ̪LMG );
[ D7-4 ]
1. SELECT Product.pNo, pName, unitPrice, COUNT (name) FROM Product LEFT OUTER JOIN Author ON Product.pNo=Author.pNo GROUP BY Product.pNo, pName, unitPrice;
3.SELECT SUM (salePrice) FROM Transaction NATURAL JOIN Record ...