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

Message passing is both time- and space-coupled – that is, messages are both directed towards a particular entity and require the receiver to be present at the time of the message send. Consider the case, though, where messages are directed towards a name rather than an address and this name is resolved using DNS. Does such a system exhibit the same level of indirection?

What will be an ideal response?

Computer Science & Information Technology

Using the ifconfig command in Windows will produce results for network configuration information being used by the computer.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

If you have a reference that is very long and would require a lot of space if entered as a footnote at the bottom of the page, it is best to reference in a(n) ________

Fill in the blank(s) with correct word

Computer Science & Information Technology

The ________ on a computer is the master user account that has the authority to add new users

A) lead user B) supervisor C) administrator D) executive

Computer Science & Information Technology