Display the first & last names of students (use the format: in a single column), and the number of classes they are enrolled in, for students who are enrolled in more than 2 classes.
What will be an ideal response?
```SELECT first_name||' '||last_name, COUNT(e.student_id)
FROM student s, enrollment e
WHERE s.student_id = e.student_id
GROUP BY first_name, last_name
HAVING COUNT(e.student_id) > 2
SELECT first_name||' '||last_name
FROM student st
WHERE 2 < (SELECT COUNT(*)
FROM enrollment e
WHERE e.student_id=st.student_id)```
You might also like to view...
Which of the following DC voltage levels is produced by a 24-pin ATX power supply? (choose all that apply)
a. +5V b. +3.3V c. +1.35V d. +12V
Which of the following is an example of an appropriate name for a control?
A. BtnMessage B. btnExit C. labelmessage D. housepicturebox
One of the biggest concerns about Windows operating systems is the need for aggressive patch management to combat the many viruses and worms that target these systems.
Answer the following statement true (T) or false (F)
The ____________________ element does not accept the padding property, so you have to apply it to the
Fill in the blank(s) with the appropriate word(s).