id type date amount
1 tank 21/6/2012 5000
2 car 21/6/2012 3000
3 car 21/6/2012 3000
4 tank 19/4/2015 5000
5 car 19/4/2015 3000
6 tank 21/6/2012 5000
7 tank 21/6/2012 5000
8 car 21/6/2012 3000
อยากให้มันสรุปออกมาว่า
วันที่21/6/2012
car = 3 total amount = 9000
tank = 3 total amount = 15000