Show all students (use the format: , in a single column) who are enrolled in more than two classes. (7 rows)
What will be an ideal response?
```
SELECT st.last_name||', '||substr(st.first_name,1,1)
FROM student st
WHERE 2 < (SELECT COUNT(*)
FROM enrollment e
WHERE e.student_id = st.student_id)
```
Computer Science & Information Technology
You might also like to view...
A set of rules that Access uses to ensure that the data between related tables is valid
a. Cascade relationship b. Referential integrity c. Relationship balance
Computer Science & Information Technology
The ____ function reads the contents of a text file that stores each individual line as an element of an indexed array.
A. file() B. get_file() C. read_file() D. open_file()
Computer Science & Information Technology