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...
After disabling SSID broadcast, a network administrator still sees the wireless network listed in available networks on a client laptop. Which of the following attacks may be occurring?
A. Evil Twin B. ARP spoofing C. Disassociation flooding D. Rogue access point E. TKIP compromise
Answer the following statements true (T) or false (F)
1) Unary operators associate from right to left. 2) If an increment or decrement operator is placed before a variable, it is referred to as the prefix increment or prefix decrement operator, respectively. If an increment or decrement operator is placed after a variable, it is referred to as the postfix increment or postfix decrement operator, respectively. 3) When instance variables of the simple types are declared in a class, they're automatically assigned default values unless specified otherwise by the programmer. Variables of type bool and String are given null by default; everything else is assigned 0. 4) You can create your own simple types.