[docs fix] Issue Snailclimb#2109

huyangdev · huyangdev · commit c188cb6fc7be · 2023-08-02T16:52:20.000+08:00
diff --git a/docs/database/sql/sql-questions-01.md b/docs/database/sql/sql-questions-01.md
@@ -953,10 +953,9 @@ WHERE condition;
 ```sql
 SELECT cust_id
 FROM Orders
-WHERE order_num IN (SELECT order_num
+WHERE order_num IN (SELECT DISTINCT order_num
     FROM OrderItems
-    GROUP BY order_num
-    HAVING Sum(item_price) >= 10)
+    where item_price >= 10)
 ```
 
 ### 确定哪些订单购买了 prod_id 为 BR01 的产品（一）
