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...
Given the following method
``` static void nPrint(String message, int n) { while (n > 0) { System.out.print(message); n--; } } ``` What is k after invoking nPrint("A message", k)? int k = 2; nPrint("A message", k); a. 0 b. 1 c. 2 d. 3
________ is a method of communication in which a dedicated connection is formed between two points and the connection remains active during the transmission
Fill in the blank(s) with correct word
All layout managers implement the interface ________.
a. LayoutInterface b. InterfaceLayoutManager c. LayoutManagerInterface d. LayoutManager
A new slide is created when the Decrease List Level button is clicked and the insertion point is positioned in the highest-level bullet point
Indicate whether the statement is true or false