Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please i need this in 1 hr Write SQL queries that will do the following Patient Prescription ID Pname City Patient ID Medicine.code Clinic 112233445

please i need this in 1 hr image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Write SQL queries that will do the following Patient Prescription ID Pname City Patient ID Medicine.code Clinic 112233445 Adam Beirut 112233445 Nx306 Well Nutrition 998877665 Bob Saida 112233445 Pa003 Healthy Clinic 556677889 Sara Zahle 998877665 Pa003 Safe Clinic 443322445 Eve Tyre 443322445 Ad500 Safe Clinic 443322445 Nx306 Well Nutrition Medicine code Muname Ingredients Price Pa003 Panadol Potassium, Paracetamol. Starch S.S Nx306 Nexume 20.0 Magnesium, Polysorbate, Glyceryl Acetaminophen. Paracetamol Ad500 Adol 3.0 Ap800 Aspirin Acetysalicylic Acid, Starch 8.55 List the name and the ID of all patients Your answer List the price of Medicine called Nexume Your answer Find the names of patients who have at least one prescription. Your answer Find the names of patients who have a prescription that contains the medicine called Panadol.* Your answer Find the average price of medicines Your answer Find total price of medicines prescribed for a patient called Adam. Your answer Find the names of the patients who have prescriptions from the 'Well Nutrition clinic Your answer Find the maximum price of a medicine Your answer Find the name of the medicine(s) that have the lowest price Your answer Find the name(s) of patient(s) who have more than one prescription Your answer Find all the information about all medicines sorted in the ascending order of price. Your answer Find the name of all medicines that have an ingredient called 'paracetamol Your answer Find the name of all patients whose ID ends with 445'* Your answer Add new medicine to the database Your answer Change the price of Panadol' medicine to 4 Your

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Database Systems

Authors: Sham Navathe,Ramez Elmasri

5th Edition

B01FGJTE0Q, 978-0805317558

More Books

Students also viewed these Databases questions

Question

LO1 Explain how the workforce is changing in unpredicted ways.

Answered: 1 week ago

Question

LO6 List the components of job descriptions.

Answered: 1 week ago