Hi guys !
Please help make a sql-query -
There are three tables -
table STUDENT
(
STUDENT_ID NUMERIC not null,
SURNAME VARCHAR(60),
);
table SUBJECT
(
SUBJ_ID NUMERIC not null,
SUBJ_NAME VARCHAR(100),
);
table EXAM_MARKS
(
EXAM_ID NUMERIC not null,
STUDENT_ID NUMERIC not null,
SUBJ_ID NUMERIC not null,
MARK NUMERIC
);
please tell me - which sql-query is needed to get a list of students who receive a positive assessment in all subjects?
Can I do this job without subqueries?
Thanks in advance!