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...

This means to increase a value:

a. decrement b. increment c. modulus d. parse e. None of these

Computer Science & Information Technology

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

Computer Science & Information Technology

You should use discretion when adding life events to your Timeline

Indicate whether the statement is true or false

Computer Science & Information Technology

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

Computer Science & Information Technology