List all students (use the format: , in a single column) in sections with fewer than 5 students enrolled. Do not show any duplicate student names .
What will be an ideal response?
```SELECT last_name||', '||first_name
FROM student
WHERE student_id IN (SELECT student_id
FROM enrollment
WHERE section_id IN (SELECT section_id
FROM enrollment
GROUP BY section_id
HAVING COUNT(*) < 5))```
You might also like to view...
This means to increase a value:
a. decrement b. increment c. modulus d. parse e. None of these
The easiest way to close an open window is to click the ____ button on the window's title bar.
A. Close Project B. New Project C. New Window D. Close
You should use discretion when adding life events to your Timeline
Indicate whether the statement is true or false
Controls such as combo boxes and list boxes are usually added to forms when working in Layout view
Indicate whether the statement is true or false