mysql統計テーブル内の受注が数値より大きい

面接で聞かれた希望は皆さんの役に立つことを望んで、日常の小さな知識を記録します.
まずデータテーブルです

mysql> select * from order_list;
+------------+--------+-------+---------------------+
| id         | name   | price | data                |
+------------+--------+-------+---------------------+
| 2019101301 |      |   199 | 2019-10-13 17:24:34 |
| 2019101302 |      |    99 | 2019-10-13 17:27:34 |
| 2019101303 |      |   299 | 2019-10-13 17:32:34 |
| 2019101304 |      |    89 | 2019-10-13 17:39:18 |
| 2019101305 |      |    39 | 2019-10-13 17:24:34 |
| 2019101306 |      |    69 | 2019-10-13 17:39:19 |
+------------+--------+-------+---------------------+
6 rows in set (0.00 sec)

sql出力当日消費が89より大きいリストSELECT SUM(price),name FROM order_list GROUP BY name HAVING SUM(price)>89 ;を書く
結果は次のとおりです.

mysql> SELECT SUM(price),name FROM order_list GROUP BY name HAVING SUM(price)>89 ;
+------------+--------+
| SUM(price) | name   |
+------------+--------+
|        498 |      |
|         99 |      |
|        108 |      |
+------------+--------+
3 rows in set (0.00 sec)