I am a beginner with SQL syntax. I have 2 tables called STUDENT
and EXAMINATION
and I am, in 1 line, trying to write a query to print ID
, SUBJECT
and NUMBER_OF_TIMES
. I am not told which column belongs to which table but my guess is that ID
belongs to STUDENT
and SUBJECT
belongs to EXAMINATION
. NUMBER_OF_TIMES
is just how many times the same student has taken that subject exam.
I tried SELECT STUDENT.ID, EXAMINATION.SUBJECT, NUMBER_OF_TIMES
but no luck.