Write following SQL Queries:A simple database composed of the following tables: PATIENT, DOCTOR, DRUG, and PRESCRIPTION, List all the rows in which the prescription dates occur on or after November 14. How many doctors provide prescriptions with 30 tablets in total? List doctor’s details where speciality is either Dermatology or Neurology. (Use INoperator). List the results by the first name in ascending order and the last name indescending order Find all patients rows whose first names include ‘George’ (Assume case sensitivity). List number of patients that do not have a phone number. How many drugs with price < 40$? How many prescriptions are generated for each patient, limit the listing to patients who have more than 2 prescriptions? List the drug codes and prices (rounded to one decimal place). How many doctors prescribe the drug code KO15? List all drugs with their expiration date (one year from the date of manufacturer) List all drugs whose prices are between $50 and $100. List number of female patients born in 1970
Please help with the following:
Write following SQL Queries:A simple
-
List all the rows in which the prescription dates occur on or after November 14.
-
How many doctors provide prescriptions with 30 tablets in total?
-
List doctor’s details where speciality is either Dermatology or Neurology. (Use INoperator). List the results by the first name in ascending order and the last name indescending order
-
Find all patients rows whose first names include ‘George’ (Assume case sensitivity).
-
List number of patients that do not have a phone number.
-
How many drugs with price < 40$?
-
How many prescriptions are generated for each patient, limit the listing to patients who
have more than 2 prescriptions?
-
List the drug codes and prices (rounded to one decimal place).
-
How many doctors prescribe the drug code KO15?
-
List all drugs with their expiration date (one year from the date of manufacturer)
-
List all drugs whose prices are between $50 and $100.
-
List number of female patients born in 1970
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
