Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please i need this quickly List the name and the ID of all patients * Your answer List the price of Medicine called Nexume *

Please i need this quickly

image text in transcribed

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 *

Write SQL queries that will do the following Patient ID Puname City Prescription Patient ID Medicine.code 112233445 Nx306 112233445 Adam Beirut Clinic Well Nutrition Healthy Clinic 998877665 Bob Salda 112233445 Pa003 556677889 Sara Zahle 998877665 Pa003 Safe Clinic 443322445 Eve Tyre 443322445 Ad500 Safe Clinic 443322445 Nx306 Well Nutrition Medicine code Ingredients Price Pa003 M..name Panadel Nexume 5.5 Potassium, Paracetamol, Starch Magnesium, Polysorbate, Glyceryl Nx306 20.0 Ad500 Adol Acetaminophen, Paracetamol 3.0 Ap800 Aspirin Acetysalicylic Acid, Starch 8.55

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

Database Marketing The Ultimate Marketing Tool

Authors: Edward L. Nash

1st Edition

0070460639, 978-0070460638

Students also viewed these Databases questions

Question

Question May a taxpayer roll over money from an IRA to an HSA?

Answered: 1 week ago

Question

Question What is the doughnut hole in HSA coverage?

Answered: 1 week ago