1 Using the single table database PATIENT you have created a Write an SQL query to list all Mr Jones ' patients b Write an SQL query to list all the patients not in ward 6 c Write an SQL query to list all the patients who arrived on 12 11 2022 d Write an SQL query to list all the patients who arrived between 12 10 2022 AND 30 10 2022

Question

1 Using the single table database PATIENT you have created  a Write an SQL query to list all Mr Jones ' patients  b Write an SQL query to list all the patients not in ward 6  c Write an SQL query to list all the patients who arrived on 12 11 2022  d Write an SQL query to list all the patients who arrived between 12 10 2022 AND 30 10 2022

SolutionInn · Accepted Answer

The Answer is in the image, click to view ...

Question: 1 Using the single table database PATIENT you have created. a Write an SQL query to list all Mr Jones' patients. b Write an SQL

Step by Step Solution