I have the following problem, I have 1 table in mysql where I have the information of people who have a debt from a clothing store for several years, what I want is a query that gives me the name of the person and that adds up your debt.
Example of the table and its data:
nombre | año | monto Pepe | 2011 | 100.00 Pepe | 2012 | 300.00 Pepe | 2016 | 900.00 Maria | 2011 | 100.00 Maria | 2012 | 530.00
Pepe | 2011 | 13000.00 Maria | 2012 | 630.00
The year does not matter I just want the sum.