plzzzzzzz helllllp meeee pllllzzzzzzzzz !!!

database ...

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

Answer the following Queries. Feel free to use any of the views that you will create in part (a):

For each Job Class list all the staff members belonging to this class.

Find all Volunteers who do not have any skills.

List all Patients who are also Volunteers at the Hospital.

Find each Outpatient who has been visited exactly once.

For each Skill list the total number of volunteers and technicians that achieve this skill.

Find all Care Centers where every bed is assigned to a Patient (i.e. no beds are available).

List all Nurses who have an RN certificate but are not in charge of a Care Center.

List all Nurses that are in charge of a Care Center to which they are also assigned.

List all Laboratories, where all assigned technicians to that laboratory achieve at least one skill.

List all Resident patients that were admitted after the most current employee hire date.

Find all Patients who have been admitted within one week of their Contact_Date.

List all Physicians who have made more than 3 visits on a single day.