Plzzz hellp me !!!! Plzzz Database ! I want two Query Implementation ... Here gi

Question

Plzzz hellp me !!!! Plzzz

Database !

I want two Query Implementation ...

Here give out the SQL views and queries. For each one; write the view/query statement that you selected then write its SQL solution.

1- Retrieve the names of companies who haven't manufactured any drugs. (This is an Example)

SELECT   Cname

FROM       Company

WHERE   NOT EXISTS ( SELECT *

               FROM Drug

                  WHERE Cname=PCname);

You have to create two views and eight queries. Choose them from the list then indicate their implementation and results. Note: The values on the blue color can be change according to the entered data

Explanation / Answer

1)

Find all Volunteers who do not have any skills.

SELECT Volunteers
FROM Volunteer
WHERE skill IS NULL;

2)

List all Patients who are also Volunteers at the Hospital.

SELECT   pname

FROM       person

WHERE EXISTS ( SELECT pname

               FROM patient

&&

SELECT vname

               FROM volunteer);

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.