Suggestion for SQL Quiz for Take Home Test Dear Teaching Team and Everyone, I have a suggestion and at the same time will help everyone with this: Question 3 Question: Find the client details for clients whose hired vehicle has travelled between 5,000 and 20,000 kilometres. Suggestion: I put the correct query, but the answer check is wrong and I cannot even find out what is wrong because there is no sample data that I can check or even use. Question 6 Question: List all vehicles (registration number and fleet number) that have been hired and their associated vehicle types. Only include vehicles that have been hired (use a Join). Suggestion: Explicitly specify which columns from vehicle types should be included, also my project 2 structure differs from the one used in the quiz and I have to do multiple attempts and "guess" which columns belong to which. Help for others: The required fields are RegNum, FleetNum, Make, Model Question 7: List all vehicles that are either hybrid or luxury, but not both (you must use a Set operation) Suggestion: I submitted the query that I thought was correct, however it turned out wrong so I got 0.1 penalty. I tried finding out what the criteria by running this but then I wasted another 0.1 because it impose strict check to use SET operations. Either the sample data should be provided along with the column names and the final expected column should be specified. Help for others: You should select only the VehicleID, I think the other column are Fuel and Body Type I think this test is very inefficient if the student have to "guess" everything from the structure to the data. Especially with the penalty being applied it makes it "punishing" to try and figure out what is wrong. Sure it is a great way for student to learn how to troubleshoot and figure out relations, but just like the lab this take home test have the penalty being applied so most of the time we will waste our chance just to figure out the column name. What I would suggest for the next semester to reduce the pain poin for the next batch of students: 1. For the take home quiz to provide the database schema like usual labs, so student can check the actuality of their query before submitting 2. Remove the penalty so student can fiddle with the data (Like in question 3, you can actually troubleshoot it by doing SELECT * FROM the HiredVehicle tables and then to check what is wrong, but with the penalty, it makes student hesitate to troubleshoot what is wrong with their query). Not to mention some of the students might even "waste" their score because they got the column name wrong. 3. Have the first few tries to have no penalty. This way for students who put wrong column name they don't have their score reduced yet.

Quick heads up, doing Results in this entries:

Yeah the teaching team is always creating vague and confusing questions in the test and labs and they always have typos in the labs as well if you guys are reading this you should do better and write the questions more clearly? Look I am understand that the team are busy people but at least make the questions more clear? Teaching team do better!

Adding another entry here for question 7 Assertion always expect **VehicleID** but no matter what I did (even already using **as "VehicleID"**) my result still have the output in Vehicleid (Which in incorrect). I think it is a problem from the python assertion code, teaching team might take a look into it first Because I tried in my local database and it shows correctly (which is expected since I have already used alias (as))

Except for any general comments, you are not allowed to discuss the test with each other or on the forums. I made that clear. If you have queries, you should email them to the teaching team.

Thank you. We will check that.