-1

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!

3
Contributors
6
Replies
7
Views
6 Years
Discussion Span
Last Post by vedro-compota
1
SELECT

STUDENT.SURNAME

FROM

EXAM_MARKS

INNER JOIN STUDENT ON

EXAM_MARKS.STUDENT_ID = STUDENT.STUDENT_ID

WHERE

MARK > whatevernumberyouwantitobegreaterthan

Edited by jlego: n/a

Votes + Comments
++++++++++++
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.