feat: add sql solution to lc problems: No.1527,1667

YangFong · YangFong · commit 736c9eba4014 · 2022-04-07T10:24:23.000+08:00
- No.1527.Patients With a Condition
- No.1667.Fix Names in a Table
diff --git a/solution/1500-1599/1527.Patients With a Condition/README.md b/solution/1500-1599/1527.Patients With a Condition/README.md
@@ -59,7 +59,15 @@ Bob 和 George 都患有代码以 DIAB1 开头的疾病。
 ### **SQL**
 
 ```sql
-
+SELECT
+    patient_id,
+    patient_name,
+    conditions
+FROM
+    patients
+WHERE
+    conditions LIKE 'DIAB1%'
+    OR conditions LIKE '% DIAB1%';
 ```
 
 <!-- tabs:end -->
diff --git a/solution/1500-1599/1527.Patients With a Condition/README_EN.md b/solution/1500-1599/1527.Patients With a Condition/README_EN.md
@@ -59,7 +59,15 @@ Patients table:
 ### **SQL**
 
 ```sql
-
+SELECT
+    patient_id,
+    patient_name,
+    conditions
+FROM
+    patients
+WHERE
+    conditions LIKE 'DIAB1%'
+    OR conditions LIKE '% DIAB1%';
 ```
 
 <!-- tabs:end -->
diff --git a/solution/1500-1599/1527.Patients With a Condition/Solution.sql b/solution/1500-1599/1527.Patients With a Condition/Solution.sql
@@ -0,0 +1,9 @@
+SELECT
+    patient_id,
+    patient_name,
+    conditions
+FROM
+    patients
+WHERE
+    conditions LIKE 'DIAB1%'
+    OR conditions LIKE '% DIAB1%';
diff --git a/solution/1600-1699/1667.Fix Names in a Table/README.md b/solution/1600-1699/1667.Fix Names in a Table/README.md
@@ -53,8 +53,31 @@ Result table:
 
 ### **SQL**
 
+MySQL
+
 ```sql
+SELECT
+    user_id,
+    CONCAT(UPPER(LEFT(name, 1)), LOWER(SUBSTRING(name, 2))) AS name
+FROM
+    users
+ORDER BY
+    user_id;
+```
 
+SQL Server
+
+```sql
+SELECT
+    user_id,
+    CONCAT(
+        UPPER(LEFT(name, 1)),
+        LOWER(SUBSTRING(name, 2, DATALENGTH(name)))
+    ) AS name
+FROM
+    users
+ORDER BY
+    user_id;
 ```
 
 <!-- tabs:end -->
diff --git a/solution/1600-1699/1667.Fix Names in a Table/README_EN.md b/solution/1600-1699/1667.Fix Names in a Table/README_EN.md
@@ -52,8 +52,31 @@ Users table:
 
 ### **SQL**
 
+MySQL
+
 ```sql
+SELECT
+    user_id,
+    CONCAT(UPPER(LEFT(name, 1)), LOWER(SUBSTRING(name, 2))) AS name
+FROM
+    users
+ORDER BY
+    user_id;
+```
 
+SQL Server
+
+```sql
+SELECT
+    user_id,
+    CONCAT(
+        UPPER(LEFT(name, 1)),
+        LOWER(SUBSTRING(name, 2, DATALENGTH(name)))
+    ) AS name
+FROM
+    users
+ORDER BY
+    user_id;
 ```
 
 <!-- tabs:end -->
diff --git a/solution/1600-1699/1667.Fix Names in a Table/Solution.sql b/solution/1600-1699/1667.Fix Names in a Table/Solution.sql
@@ -0,0 +1,10 @@
+SELECT
+    user_id,
+    CONCAT(
+        UPPER(LEFT(name, 1)),
+        LOWER(SUBSTRING(name, 2, DATALENGTH(name)))
+    ) AS name
+FROM
+    users
+ORDER BY
+    user_id;
