Using these tables write sql queries that will do the following:

1.Write a query that will give a list of prescription dates and patient names

2.Write a query that will give a list of prescription dates, patient names, and drug names

3.Write a query that will give a list of prescriptions, patient names, drug names, and physician names

4.Write a query that will give a list of drugs that have not been prescribed

5.Write a query that will give a list of physicians and the count of prescriptions they have ordered.

PATIENT DRUG PATIENT ID PK DRUG ID PK FIRST_NAME DRUG_NAME LAST_NAME DRUG NDC DOB MANUFACTURER ID PRESCRIPTION PK PRESCRIPTION ID FK DRUG ID FK PHYSICIAN ID FK PATIENT_ID PHYSICIAN PRESCRIPTION DATE PK PHYSICIAN ID FIRST_NAME LAST_NAME DOB ZIP