面试遇到的SQL

1、查询出来2021-11-10 上午9点 至 2021-11-10 下午 1点 剩余的 balance 车票数量

select sum(`blance`) as num from `t_hcp` where concat(`the_date`,' ',`the_time`) between '2021-11-10 09:00' and '2021-11-10 13:00';

mysql> select * from `t_hcp`;
+----+--------+------------+----------+--------+
| id | blance | the_date   | the_time | type   |
+----+--------+------------+----------+--------+
|  1 |    120 | 2021-11-10 | 12:19    | 动车   |
|  2 |    890 | 2021-11-10 | 09:08    | 动车   |
|  3 |    110 | 2021-11-05 | 15:50    | 普快   |
|  4 |      8 | 2021-11-09 | 14:00    | 动车   |
+----+--------+------------+----------+--------+

mysql> select sum(`blance`) as num from `t_hcp` where concat(`the_date`,' ',`the_time`) between '2021-11-10 09:00' and '2021-11-10 13:00';
+------+
| num  |
+------+
| 1010 |
+------+
1 row in set (0.01 sec)