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…

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:

SQL > SELECT p.prod_id, count(s.prod_id) FROM products p ______________ sales s ON p.prod_id = s.prod_id GROUP BY p.prod_id; Which two JOIN operations can be used to obtain the required output?