id |
person |
task |
duration |
deadline_day |
deadline_month |
1 |
John |
dust the floors |
40 |
4 |
3 |
2 |
Matt |
do the dishes |
15 |
2 |
2 |
3 |
Mary |
dusting |
40 |
3 |
2 |
4 |
Chloe |
cleaning the windows |
65 |
4 |
5 |
5 |
John |
wash the floors |
60 |
3 |
3 |
6 |
Bridget |
take out the trash |
15 |
3 |
3 |
7 |
Matt |
do the laundry |
18 |
2 |
2 |
8 |
Bridget |
water the plants |
15 |
3 |
3 |
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(
SELECT Todo_tbl.person, SUM(Todo_tbl.duration) FROM Todo_tbl JOIN Statistics_t' at line 1