10. 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. (7 rows)
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...
If numbers appear for the column headings, the reference style for Excel is ________
Fill in the blank(s) with the appropriate word(s).
____ takes a current snapshot of the security of the organization as it now stands.
A. Asset modeling B. Asset tree C. Threat modeling D. Vulnerability appraisal
A tool used to generate data restrictions for a field.
What will be an ideal response?
Bioprinting, which uses 3D printers to build human parts and organs from actual human cells, is widely considered to be unethical.
Answer the following statement true (T) or false (F)