[G_SQL] pp133 : 어느 과목에서 어느 여학생이 A학점을 얻었는가?

-- p133 : 어느 과목에서 어느 여학생이 A학점을 얻었는가?

SELECT student_name, course_name, grade
    FROM (STUDENTS
            INNER JOIN ENROLLS
            ON STUDENTS.student = ENROLLS.student)
        INNER JOIN COURSES
        ON ENROLLS.course = COURSES.course
    WHERE gender = 'F' AND Grade = 4;
   
   

SELECT student_name, course_name, grade
FROM STUDENTS, ENROLLS, COURSES
WHERE gender = 'F' AND
grade = 4 AND
STUDENTS.student = ENROLLS.student AND
ENROLLS.course = COURSES.course