List Charles Lowry's students (use the format: , in a single column) that live in New Jersey. Sort the result by last name.
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...
Which element of a table can vary in width from row to row?
A) Text B) Columns C) Graphics D) Rows
Computer Science & Information Technology
?To add pictures, videos, or documents in a Sway, select a card in the left pane and __________.
Fill in the blank(s) with the appropriate word(s).
Computer Science & Information Technology