Interview question for Mysql

gistfile1.txt

CREATE TABLE `payments` (
 `id` INT(11) NOT NULL AUTO_INCREMENT,
 `amount` DECIMAL(8,2) NOT NULL,
 `date` DATE NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=INNODB DEFAULT CHARSET=utf8;
 
INSERT INTO `payments` (`amount`,`date`) VALUES ('3.44','2012-01-01');
INSERT INTO `payments` (`amount`,`date`) VALUES ('344','2012-02-01');
INSERT INTO `payments` (`amount`,`date`) VALUES ('66.48','2012-03-01');
INSERT INTO `payments` (`amount`,`date`) VALUES ('111','2012-04-01');


- Generate a table that will look like this

Date                               Amount
2012-01-01                      3.44
2012-02-01                      3.44 + 344
...

Answer : http://sqlfiddle.com/#!2/843f41/32