Refer to Figure II Promote all students who received an A in any class to studen

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;

Related Questions

Navigate

• Browse (All)
• Browse R
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.