Home › Forums › kdb+ › KXSQL Question 6 › Reply To: KXSQL Question 6
-
Hi @masmail
I’ve noticed a few things from your screenshots:
If you take a look at the challenge.quke file, you will see the correct answer should be as follows (screenshot below). So you don’t seem to have the correct values.
The problem lies in your table join. To be able to join two or more tables, you must use a related column. In this case our related column is ‘student_no’.
To do this I’m going to use an INNER JOIN:
"INNER JOIN students ON results.student_no = students.student_no"
Also to achieve the correct value when rounding I advise you use ROUND instead of FLOOR.
Hope this helps!
Thanks,
Megan