Show instructors (along with their course numbers and section numbers) teaching class sections with students whose last name begins with ‘M’. (20 rows)
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%'
```
```
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...
U. S. Circuit Courts hear cases referred from lower federal district courts, known as U.S. ________ Courts
Fill in the blank(s) with the appropriate word(s).
Rockwell Automation refers to the output instruction as the ____________________ instruction.
Fill in the blank(s) with the appropriate word(s).
What problem drives the recommendation to physically destroy SSD drives to prevent data leaks when they are retired?
A. Degaussing only partially wipes the data on SSDs. B. SSDs don't have data remanence. C. SSDs are unable to perform a zero fill. D. The built-in erase commands are not completely effective on some SSDs.
A table placed inside another table is called a double table.
Answer the following statement true (T) or false (F)