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


 UWA week 35 (2nd semester, week 6) ↓
SVG not supported

Login to reply

👍?
helpful
3:55pm Wed 28th Aug, Wujiang H.

Hi Dr Nasim, I am confused about Q10. What is the problem with the following query? SELECT job_id, po_date FROM pos WHERE po_date < '1990-01-03' GROUP BY job_id; A. The date is mentioned incorrectly B. po_date is not used in group by and is also not an aggregate function C. Order of groupby and where is wrong D. Group by always need to have a Having Statement The code provided in the question is runnable. Then, I changed it to "GROUP BY job_id, po_date" The code was also runnable and displayed the same result as without "po_date". Additionally, I changed '1990-01-01' to '1989-01-03' The code is still runnable and displays the correct result. Therefore, I am not sure why B is correct. Thank you for your assistance. Kind regards, Nate



This article has 1 attachment:

 

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