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 134 other people reading this forum.


 UWA week 34 (2nd semester, week 5) ↓
SVG not supported

Login to reply

👍?
helpful
10:06am Wed 21st Aug, Adam W.

Was anyone still having issues? If you want to break the question down into what it is asking for each part of the SQL statement: for the SELECT part, it is asking to use one of the aggregate functions (https://www.w3schools.com/sql/sql_aggregate_functions.asp), to get two columns, one showing the smallest of all of the on_hand multiplied by the price of the item, and then the largest of the same type of calculation its FROM the items table, so nothing too fiddly there and in the WHERE section, it wants you to limit to results where the on_hand is greater than or equal to 100. remember you can do this check in one operation. Hope this helps. Adam. "Daniel Cartagena Nunez" <24*9*8*9@s*u*e*t*u*a*e*u*a*> wrote:
> There seems to be an error with the question 1 on lab 3, where it ask a query where items.on_hand is more than or equal to 100, but if you use the equal to the answer is incorrect, so its only more than. > (:

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