SQL Question

Aug 9 2013 11:33 PM

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.