Which two queries give the required result?

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 a customers in ‘Tokyo’.
Which two queries give the required result?

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 a customers in ‘Tokyo’.
Which two queries give the required result?

A.
Option A

B.
Option B

C.
Option C

D.
Option D

Explanation:



Leave a Reply 2

Your email address will not be published. Required fields are marked *


shiman

shiman

D also execute correctly but with 2 unnecessary id columns