DROP TABLE bench;

CREATE TABLE bench (
	mark VARCHAR(100) NOT NULL,
	time TIME NOT NULL,
	compilation ENUM('byte','opt') NOT NULL,
	test VARCHAR(100) NOT NULL,
	result ENUM('ok','fail') NOT NULL,
	options SET('no-gc')
);

DESCRIBE bench; 

select mark, SEC_TO_TIME(SUM(TIME_TO_SEC(time))) from bench where options = '' group by mark;
select mark, SEC_TO_TIME(SUM(TIME_TO_SEC(time))) from bench where test LIKE '%uto.ma' and options = '' group by mark;
select mark, SEC_TO_TIME(SUM(TIME_TO_SEC(time))) from bench where options = 'no-gc' group by mark;
select mark, SEC_TO_TIME(SUM(TIME_TO_SEC(time))) from bench where test LIKE '%uto.ma' and options = 'no-gc' group by mark;
