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
D is wrong because of ORA-25154: column part of USING clause cannot have qualifier
Meaning you cannot use c.cust_id in the select clause instead it should just be cust_id without the qualifier “c”.
B should have been join, on, join , on instead of join, join, join, on,on, on