Hi Guys,
this is my table
mysql> select * from data;
+------------+-----------------------------+---------+----------+
| date | name | missing | advanced |
+------------+-----------------------------+---------+----------+
| 2007-04-05 | Abraao | 2 | |
| 2007-04-06 | Adeilson Sousa | | 50,00 |
| 2007-03-14 | Abraao | | 35,00 |
| 2007-04-07 | Roberto Saturnino Alves| 2 | 20,00 |
| 2007-04-06 | Roberto Saturnino Alves| | 35,00 |
| 2007-04-07 | Abraao | | 40,00 |
| 2007-04-10 | Raphael Miguel Targin | 2 | 35,00 |
| 2007-04-10 | Rosemere Santana Neves | | 45,00 |
| 2007-04-10 | Carlos Frederico De Andrade | 1 | 35,00 |
| 2007-04-10 | Bruno Miguel Targino | 2 | 25,00 |
| 2007-04-10 | Vania Soraia Vaz Naia | 5 | 15,00 |
+------------+-----------------------------+---------+----------+
11 rows in set (0.00 sec)
i need to sum the values of advanced by the name of the people...
could someone help me please?
this is my table
mysql> select * from data;
+------------+-----------------------------+---------+----------+
| date | name | missing | advanced |
+------------+-----------------------------+---------+----------+
| 2007-04-05 | Abraao | 2 | |
| 2007-04-06 | Adeilson Sousa | | 50,00 |
| 2007-03-14 | Abraao | | 35,00 |
| 2007-04-07 | Roberto Saturnino Alves| 2 | 20,00 |
| 2007-04-06 | Roberto Saturnino Alves| | 35,00 |
| 2007-04-07 | Abraao | | 40,00 |
| 2007-04-10 | Raphael Miguel Targin | 2 | 35,00 |
| 2007-04-10 | Rosemere Santana Neves | | 45,00 |
| 2007-04-10 | Carlos Frederico De Andrade | 1 | 35,00 |
| 2007-04-10 | Bruno Miguel Targino | 2 | 25,00 |
| 2007-04-10 | Vania Soraia Vaz Naia | 5 | 15,00 |
+------------+-----------------------------+---------+----------+
11 rows in set (0.00 sec)
i need to sum the values of advanced by the name of the people...
could someone help me please?
Comment