List Charles Lowry's students (use the format: , in a single column) that live in New Jersey. Sort the result by last name. (14 rows)

What will be an ideal response?

```
SELECT st.last_name||', '||st.first_name Name
FROM student st, enrollment e, section s, instructor i,
zipcode z
WHERE st.student_id = e.student_id
AND e.section_id = s.section_id
AND i.instructor_id = s.instructor_id
AND i.last_name = 'Lowry'
AND st.zip = z.zip
AND z.state = 'NJ'
ORDER BY st.last_name
```

Computer Science & Information Technology

You might also like to view...

By default, graphical components that are added to a JPanel are placed in the center of the pane.

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

Computer Science & Information Technology

In the TCP/IP stack, what layer is concerned with physically moving bits across the network's medium?

A. Internet B. Network C. Transport D. Application

Computer Science & Information Technology