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, s.course_no, s.section_no
FROM section s, instructor i
WHERE s.instructor_id = i.instructor_id
AND s.section_id IN (SELECT section_id
FROM enrollment e, student s
WHERE e.student_id = s.student_id
AND last_name like 'M%')
ORDER BY i.last_name, s.course_no, s.section_no```
You might also like to view...
Which of these does not focus on the relationship between the system analyst and the user with respect to output?
A) removal of all sources of bias from all output B) creating flexible output C) interactive design D) informing those concerned with output's biases
The capitalization for a complimentary close with two words is illustrated correctly in the following example: Sincerely yours
Answer the following statement true (T) or false (F)
Which of the following is a term that describes a log of performance and other indicators taken of a network and its server during normal operations?
A. application log B. system log C. security log D. baseline
In the accompanying figure, item A is used to identify the _______________ for a new folio.
Fill in the blank(s) with the appropriate word(s).