MySQL Kata #1

kata1.md

+------+-------+
| type | value |
+------+-------+
| a    | 2     |
+------+-------+
| a    | 5     |
+------+-------+
| c    | 1     |
+------+-------+
| b    | 8     |
+------+-------+
| c    | 3     |
+------+-------+
| a    | 2     |
+------+-------+
| b    | 4     |
+------+-------+
| a    | 2     |
+------+-------+

Quest: Return the sum of all atype records as sum_a and the sum of all b type records in sum_b in one query.

kata1.sql

CREATE TABLE `kata1` (
  `type` varchar(11) NOT NULL DEFAULT '',
  `value` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `kata1` (`type`, `value`)
VALUES
	('a',2),
	('a',5),
	('c',1),
	('b',8),
	('c',3),
	('a',2),
	('b',4),
	('a',2);

I guess there might be a more performant solution. However this fulfills all the conditions.

https://gist.github.com/etobi/01bc825e1499ccc49e02

It uses more than one query.
After wasting a lot of time with GROUP BY I denied myself the pleasure of solving this alone.
Don't think I'd figured that one out by myself.