View the Exhibit and examine PRODUCTS and ORDER_ITEMS tables.
You executed the following query to display PRODUCT_NAME and the number of
times the product has been ordered:
SELECT p.product_name, i.item_cnt
FROM (SELECT product_id, COUNT (*) item_cnt
FROM order_items
GROUP BY product_id) i RIGHT OUTER JOIN products p
ON i.product_id = p.product_id;
What would happen when the above statement is executed?
A.
The statement would execute successfully to produce the required output.
B.
Practice exams also include self assessment and reporting features 55
together.
C.
The statement would not execute because the ITEM_CNT alias cannot be displayed
in the outer query.
D.
The statement would not execute because the GROUP BY clause cannot be used in
the inline view.