Perform the following queries on the Hospital1.DB using SQL Anywhere (START EARLY!).
a. Which patients have purchased the drug "Tylenol"? List the names and addresses. Arrange them in descending order of patient name.
b. List the physician names and the number of visits supervised by each physician. Arrange them in descending order of number of visits.
c. List the Phy# and names of all physicians whose name starts with the letter "M."
d. List the names, addresses and phone#s of patients living in Fremont or San Jose. Arrange them in ascending order of the zip.
e. List the Drug# and description of drugs that have not been prescribed. Arrange them in ascending order of description.
f. How many patients are there in the database? Give the count.
g. List Visit#, PatID, Phy#, Drug#, Qnty and Amount. Calculate Amount as Price*Qnty.