Question 117:
View the Exhibit and examine the structure of the SALES and PRODUCTS tables. (Choose two.)
In the SALES table, PROD_ID is the foreign key referencing PROD_ID in the PRODUCTS table. You must list each product ID and the number of times it has been sold. Examine this query which is missing a JOIN operator:
Which two JOIN operations can be used to obtain the required output?
Answer options:
A. FULL OUTER JOIN B. JOIN C. LEFT OUTER JOIN D. RIGHT OUTER JOIN