Hi For Lab-5 Q7, can you please clarify if we need to use A- Avg(price) from items table OR B- AVG ( item.price * po_items.quantity) i.e. AVG of total_item_cost A returns an avg value of 173.37 vs B returns a value of 2478.95 if I take first approach, I only get two items with price > 173.37 which are IRN(price=500), IWS(price=350) if I take second approach, i get four items. both of these scenarios do not give required output. Can you please have a look at question wording and help understand?

Hi, No you do not need to use the average in Q7. Can you please post the actual question here, because i feel you may be referring to a different question.

Here is the Question: Find the po_ids that have ordered items costing more than the average price of all items, along with the total cost of those items. Hint use a subquery to calculate the average price of items.