Show the student roster (use the format: , in a single column) for each section that Todd Smythe teaches. Identify the section using course number AND section number.
What will be an ideal response?
``` SELECT s.course_no Course, s.section_no Section,
st.last_name||', '||st.first_name Name
FROM section s, student st, enrollment e, instructor i
WHERE s.section_id = e.section_id
AND e.student_id = st.student_id
AND i.instructor_id = s.instructor_id
AND i.last_name = 'Smythe'
AND i.first_name = 'Todd'```
You might also like to view...
By default, a(n) _________ form displays in Form view on the top half of the form and Datasheet view on the bottom half of the form
Fill in the blank(s) with correct word
Match the following terms to their meanings:
I. Project II. Properties III. Modules IV. Procedures V. Code window A. Named sequences of statements that perform a series of actions for a defined task B. Attributes for a selected object in the Project Explorer C. A collection of modules and objects needed to run an application D. A workspace text editor E. Containers to organize programming code