commit 61054fd2b5705d233cb45679095a1a5627b08a32 parent f5e2baf3479d6daa841f64b030cfdc43817d55b0 Author: AndrewLockVI <andrewlaack1@gmail.com> Date: Wed, 28 Jun 2023 06:35:20 -0500 Completed patients with a condition Diffstat:
| A | patients-with-a-condition/patients-with-a-condition.sql | | | 10 | ++++++++++ |
1 file changed, 10 insertions(+), 0 deletions(-)
diff --git a/patients-with-a-condition/patients-with-a-condition.sql b/patients-with-a-condition/patients-with-a-condition.sql @@ -0,0 +1,10 @@ +--Given a a table with patients and medical records +--return all patients who have a condition which is denoted +--by DIAB1 in the conditions field followed by the condition. + +SELECT * +FROM Patients +WHERE Patients.conditions +LIKE '% DIAB1%' OR +Patients.conditions +LIKE 'DIAB1%'