Show instructors (along with their course numbers and section numbers) teaching class sections with students whose last name begins with ‘M’. (16 rows)
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...
When you click the ________ button, all tracked changes are accepted and unaccepted changes are rejected
A) End Review B) Accept All C) Stop Tracking D) Accept Changes
Paragraph spacing refers to the amount of space between lines of text within a paragraph. _________________________
Answer the following statement true (T) or false (F)
Case-Based Critical Thinking QuestionsCase 1: Human Resources ApplicationAn application used by the human resources (HR) department needs to be improved. You need to use various string manipulation properties and methods to ensure all data entered by a user are accurate and stored correctly. Each employee is assigned an employee code, such as F01234, which is stored in the strEmpCode variable. The first character is a letter for employment status (F for Full-time, P for Part-time). The next two characters are numbers representing the employee's department number. The last three characters are numbers representing a unique value for each individual employee. Which of the following statements assigns the employee's department to the strDept variable?
A. strDept = strEmpCode.Substring(0, 1) B. strDept = strEmpCode.Substring(1) C. strDept = strEmpCode.Substring(0, 2) D. strDept = strEmpCode.Substring(1, 2)
Which term is used when an event triggers an IDS alert, but the event was not malicious?
A. False positive B. True negative C. False negative D. True positive