I have two tables, Student and subjects. the relationship between the two tables is one to many.
The subject table contains the subject's name and all the tests results (marks) of that subject.
How can I get all students that are failed in a specific subject?
Thanks in advance