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))```

Computer Science & Information Technology

You might also like to view...

Concrete classes that inherit virtual functions but do not override their implementations:

a. Have vtables which are the same as those of their base classes. b. Receive their own copies of the virtual functions. c. Receive pointers to their base classes’ virtual functions. d. Receive pointers to pure virtual functions.

Computer Science & Information Technology

Which of the following statements is true?

a. The binary search algorithm is less efficient than the linear search, but it requires that the array be sorted. b. The binary search algorithm is more efficient than the linear search, but it requires that the array be unsorted. c. The binary search algorithm is more efficient than the linear search, but it requires that the array be sorted. d. The binary search algorithm is less efficient than the linear search, but it requires that the array be unsorted.

Computer Science & Information Technology