[Mysql] select 안에 select

mysql> select * from points where poid='kmin_lee';
+-------+----------+-------+----------+---------------------+
| poidx | poid     | point | okresult | po_time             |
+-------+----------+-------+----------+---------------------+
|     6 | kmin_lee |  1000 | Y        | 2022-07-03 12:44:11 |
|    18 | kmin_lee |  3200 | Y        | 2022-07-08 16:41:10 |
|    20 | kmin_lee |  4200 | N        | 2022-07-09 11:22:31 |
+-------+----------+-------+----------+---------------------+
3 rows in set (0.00 sec)

mysql> select point from points where poid='kmin_lee' and okresult='Y';
+-------+
| point |
+-------+
|  1000 |
|  3200 |
+-------+
2 rows in set (0.00 sec)

mysql> select sum(point) from points where poid='kmin_lee' and okresult='Y';
+------------+
| sum(point) |
+------------+
|       4200 |
+------------+
1 row in set (0.00 sec)

mysql> select sum(point),(select sum(point) from points where poid='kmin_lee' and okresult='N') as usepoint from points where poid='kmin_lee' and okresult='Y';
+------------+----------+
| sum(point) | usepoint |
+------------+----------+
|       4200 |     4200 |
+------------+----------+
1 row in set (0.00 sec)