Patients With A Condition Problem


Description

LeetCode Problem 1527.

Table: Patients

1
2
3
4
5
6
7
8
9
10
+--------------+---------+
| Column Name  | Type    |
+--------------+---------+
| patient_id   | int     |
| patient_name | varchar |
| conditions   | varchar |
+--------------+---------+
patient_id is the primary key for this table.
'conditions' contains 0 or more code separated by spaces. 
This table contains information of the patients in the hospital.

Write an SQL query to report the patient_id, patient_name all conditions of patients who have Type I Diabetes. Type I Diabetes always starts with DIAB1 prefix

Return the result table in any order.

The query result format is in the following example.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
Patients
+------------+--------------+--------------+
| patient_id | patient_name | conditions   |
+------------+--------------+--------------+
| 1          | Daniel       | YFEV COUGH   |
| 2          | Alice        |              |
| 3          | Bob          | DIAB100 MYOP |
| 4          | George       | ACNE DIAB100 |
| 5          | Alain        | DIAB201      |
+------------+--------------+--------------+

Result table:
+------------+--------------+--------------+
| patient_id | patient_name | conditions   |
+------------+--------------+--------------+
| 3          | Bob          | DIAB100 MYOP |
| 4          | George       | ACNE DIAB100 | 
+------------+--------------+--------------+
Bob and George both have a condition that starts with DIAB1.


MySQL Solution

1
2
3
select patient_id, patient_name, conditions
from Patients
where conditions like "%DIAB1%"




Related Posts

Bank Account Summary Problem

LeetCode 1555. Our bank records all transactions in the table...

The Most Recent Orders For Each Product Problem

LeetCode 1549. Write an SQL query to find the most...

Fix Product Name Format Problem

LeetCode 1543. Write an SQL query to report product_name in...

Unique Orders And Customers Per Month Problem

LeetCode 1565. Write an SQL query to find the number...

Patients With A Condition Problem

LeetCode 1527. Write an SQL query to report the patient_id,...