Show instructors (along with their course numbers and section numbers) teaching class sections with students whose last name begins with ‘M’.
What will be an ideal response?
```SELECT i.first_name||' '||i.last_name Name, s.course_no, s.section_no
FROM section s, instructor i, enrollment e, student st
WHERE s.instructor_id = i.instructor_id
AND e.section_id = s.section_id
AND e.student_id = st.student_id
AND st.last_name LIKE 'M%'
Alternate answers :
SELECT i.first_name||' '||i.last_name Name, s.course_no, s.section_no
FROM section s, instructor i, enrollment e, student st
WHERE s.instructor_id = i.instructor_id
AND e.section_id = s.section_id
AND e.student_id = st.student_id
AND SUBSTR(st.last_name,1,1)= 'M'
SELECT i.first_name||' '||i.last_name Name, s.course_no, s.section_no
FROM section s, instructor i, enrollment e, student st
WHERE s.instructor_id = i.instructor_id
AND e.section_id = s.section_id
AND e.student_id = st.student_id
AND INSTR(st.last_name,'M')=1```
You might also like to view...
A systems administrator is inspecting a file server setup with a RAID 10 configuration among four 160GB SAS drives. The administrator has replaced all of the drives with 500GB SAS drives. Which of the following storage tools should the administrator use NEXT to effectively administer the change?
A. Disk management tool B. Disk monitoring tool C. Disk cloning tool D. Disk partitioning tool
Which of the following commands may need to be run after a virus removal if the computer will not boot?
a. SCANDSK b. DXDIAG c. FIXMBR d. MSCONFIG