help1402

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 the 3 articles in this topic

Showing 3 of 98 articles.
Currently 2 other people reading this forum.

UWA week 12 (1st semester, week 4) ↓

LAB Q5 (all 3)

3:23pm Tue 19th Mar, ANONYMOUS

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?

LAB Q5 (all 3)

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?

LAB Q5 (all 3)

10:47am Wed 20th Mar, ANONYMOUS

Hi, I had the same problem at first - the actual syntax is not very intuitive based on the examples we've learned, but you need to try moving the brackets so that what you're multiplying is inside them like what Maira has hinted.

help1402 articles all ANNOUNCEMENTS recent articles login to post a new article help1402 topics from today and yesterday from the past week from the past two weeks ALL topics, most recent first	login chapter0 unitinfo research projects csforum csse-feedback csbreakdown cssubmit csmarks 1st semester help fora Computer Networks Data Structures and Algorithms Graphics and Animation Mobile and Wireless Computing Object Oriented Programming Open Source Tools and Scripting Software Requirements and Design Software Testing and Quality Assurance