List courses and their description whose prerequisites are taught by Nina Schorin. (13 rows)
What will be an ideal response?
```
SELECT c.course_no, c.description
FROM course c, course pr
WHERE c.prerequisite = pr.course_no
AND pr.course_no IN (SELECT s.course_no
FROM section s, instructor i
WHERE s.instructor_id = i.instructor_id
AND i.last_name = 'Schorin')
```
You might also like to view...
HTTP functions at what layer of the OSI model?
What will be an ideal response?
Which of the following is a process of borrowing identity information, such as an IP address, domain name, NetBIOS name, or TCP or UDP port numbers to hide or deflect interest in attack activities?
A. Ingress filtering B. Data authentication C. Network sniffing D. Spoofing
________ is a Word feature that modifies text to include shadows, outlines, colors, gradients, and 3-D effects
A) SmartArt B) WordArt C) Borders D) Clip art
Most of today's PC software and standard definition movies are sold as:
A. Micro SD B. Blu-ray C. CDs D. DVDs