It's UWAweek 47

help1402

This forum is provided to promote discussion amongst students enrolled in CITS1402 Relational Database Management Systems.

Please consider offering answers and suggestions to help other students! And if you fix a problem by following a suggestion here, it would be great if other interested students could see a short "Great, fixed it!"  followup message.

How do I ask a good question?
Displaying selected article
Showing 1 of 684 articles.
Currently 105 other people reading this forum.


 UWA week 40 (2nd semester, week 10) ↓
SVG not supported

Login to reply

👍?
helpful
10:24pm Sun 6th Oct, ANONYMOUS

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?

The University of Western Australia

Computer Science and Software Engineering

CRICOS Code: 00126G
Written by [email protected]
Powered by history
Feedback always welcome - it makes our software better!
Last modified  8:08AM Aug 25 2024
Privacy policy