ocp¿¼ÊÔÌâ¿âÏÂÔØ£º11g-v9.02-051-123Ì⣬ÍêÕûÌâ¿âÇëµã»÷ÕâÀïÁªÏµÀÏʦ×ÉѯÁ˽â

123. View the Exhibits and examine the structures of the PRODUCTS, SALES, and CUSTOMERS

tables.

You need to generate a report that gives details of the customer's last name, name of the product, and

the quantity sold for all customers in ' Tokyo' .

Which two queries give the required result? (Choose two.)

A. SELECT c.cust_last_name,p.prod_name, s.quantity_sold

FROM sales s JOIN products p

USING(prod_id)

JOIN customers c

USING(cust_id)

WHERE c.cust_city='Tokyo';

B. SELECT c.cust_last_name, p.prod_name, s.quantity_sold

FROM products p JOIN sales s JOIN customers c

ON(p.prod_id=s.prod_id)

ON(s.cust_id=c.cust_id)

WHERE c.cust_city='Tokyo';

C. SELECT c.cust_last_name, p.prod_name, s.quantity_sold

FROM products p JOIN sales s

ON(p.prod_id=s.prod_id)

JOIN customers c

ON(s.cust_id=c.cust_id)

AND c.cust_city='Tokyo';

D. SELECT c.cust_id,c.cust_last_name,p.prod_id, p.prod_name, s.quantity_sold

FROM products p JOIN sales s

USING(prod_id)

JOIN customers c

USING(cust_id)

WHERE c.cust_city='Tokyo';

Answer: AC

ÊÔÌâ½âÎö£º

BÓï·¨´íÎó

DÖÐp.prod_id²»Ó¦¸Ã¸úÏÞ¶¨µÄ±í±ðÃû¡£

²»Òª¶ÔUSING×Ó¾äÖÐʹÓõÄÁмÓÒÔÏÞ¶¨¡£

USING×Ó¾äÖÐÒýÓõÄÄÇЩÁв»ÄÜÔÚSQL Óï¾äµÄÈκÎλÖÃʹÓÃÏÞ¶¨´Ê(±íÃû»ò±ðÃû)¡£

Èç¹ûÔÚSQL Óï¾äµÄÁíÒ»¸öλÖÃʹÓÃÁËͬһÁУ¬Ôò²»Òª¶ÔÆäÉèÖñðÃû¡£