Refer to Figure II Promote all students who received an A in any class to studen
ID: 3773157 • Letter: R
Question
Refer to Figure II Promote all students who received an A in any class to student_teachers, using their current student name and number as the teacher name and number
SELECT DISTINCT S.student_num, student_name INTO student_teachers
FROM students AS S, enrolls AS E
WHERE grade=4
AND S.student_num = E.student_num;
SELECT INTO student_teachers
FROM students AS S, enrolls AS E
WHERE grade=4
AND S.student_num = E.student_num;
SELECT DISTINCT student_num, S.student_name INTO student_teachers
FROM students AS S, enrolls AS E
WHERE grade=4
AND S.student_num = E.student_num;
SELECT DISTINCT * INTO student_teachers
FROM students AS S, enrolls AS E
WHERE grade=4
AND S.student_num = E.student_num;
Explanation / Answer
SELECT DISTINCT S.student_num, student_name INTO student_teachers
FROM students AS S, enrolls AS E
WHERE grade=4
AND S.student_num = E.student_num;