Loading

SQL Question

Nilesh Sanyal

13y1.5kSQL

Consider following tables

STUDENT(ROLL_NO,STUDENT_NAME,ADDRESS,AGE)

DEPARTMENT(DEPT_NAME,COURSE#,TEACHER)

TIME_TABLE(COURSE#,SUBJECT_NAME,SEMESTER,TIME,ROLL_NO)

PERFORMANCE(ROLL_NO,COURSE#,GRADE)

SQL Query

Find the names of students who have secured 'A' grade in a course offered by the Physics
Department in the Winter Semester.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Iftikar Hussain13y ago
Accepted answer
Hi,
Try like this

SELECT A.STUDENT_NAME FROM STUDENT A INNER JOIN PERFORMANCE B ON A.ROLL_NO=B.ROLL_NO AND B.GRADE='A'
INNER JOIN TIME_TABLE C ON B.COURSE#=C.COURSE# AND C.SEMESTER='Winter'
INNER JOIN DEPARTMENT D ON C.COURSE#=D.COURSE# AND D.DEPT_NAME='Physics'

Regards,
Iftikar
Nilesh Sanyal13y ago
Thank you very much.