It's UWAweek 17 (1st semester, week 8)

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 97 articles.
Currently no other people reading this forum.


 UWA week 12 (1st semester, week 4) ↓
SVG not supported

Login to reply

👍?
helpful
5:55pm Tue 19th Mar, Maira A.

Hi, The question is: Display the minimum on_hand "times" price in a column called min.... I hope you can decipher it from the question. Hint: You need to get minimum of (something "times" something) ANONYMOUS wrote:
> When i use the select command to slect the min on hand then multiply it by price along with selecting the max on hand and multiplying it by price. The output appears to be correct for the max on hand times price, but for the min on hand times price it appears to have multipled the min on hand by the price of the max on hand. what am i doing wrong?

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  5:07AM Sep 06 2023
Privacy policy