One product can appear in multiple items, but one item can h…
One product can appear in multiple items, but one item can have only one product. If you want to get the average unit price across all products and average units sold across all items in one query, by joining items and products table, will the query shown below work? Choose the right answer from the given options SELECT AVG(price_per_unit) AS avg_unit_price, AVG(units_sold) AS avg_units_sold FROM items i JOINproducts pON i.product_id = p.product_id;