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_soldFROM sales s JOIN products pUSING(prod_id)JOIN customers cUSING(cust_id)WHERE c.cust_city=’Tokyo’;
B. SELECT c.cust_last_name, p.prod_name, s.quantity_soldFROM products p JOIN sales s JOIN customers cON(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_soldFROM products p JOIN sales sON(p.prod_id=s.prod_id)JOIN customers cON (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 sUSING(prod_id)JOIN customers cUSING(cust_id)WHERE c.cust_city=’Tokyo’;
|
Download Printable PDF. VALID exam to help you PASS. |
 |