SQL query

dump.sql

CREATE TABLE IF NOT EXISTS `phone_call` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user` varchar(16) NOT NULL,
  `flag` int(10) unsigned NOT NULL,
  `length` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

INSERT INTO `phone_call` (`id`, `user`, `flag`, `length`) VALUES
(1, 'pupkin', 0, 12),
(2, 'pupkin', 1, 13),
(3, 'pupkin', 0, 11),
(4, 'vasya', 1, 23),
(5, 'pupkin', 1, 2),
(6, 'vasya', 1, 3),
(7, 'pupkin', 0, 5),
(8, 'vasya', 0, 7);

query.sql

SELECT `user`, SUM(`length` * `flag`) AS `day`, SUM(`length` * (1 - `flag`)) AS `night`
FROM `phone_call`
GROUP BY `user`;