行列转换的问题

create schema if not exists temp;
use temp;

--
--工作类型表
--
create table tbl_work_type (
    `type` varchar(16) not null,
    `description` varchar(16) not null,
    primary key(`type`)
);
insert into tbl_work_type(type, description) values('A', 'A类工作时间');
insert into tbl_work_type(type, description) values('B', 'B类工作时间');
insert into tbl_work_type(type, description) values('C', 'C类工作时间');
--
--工作记录表
--
create table tbl_work_schedule (
    `id` varchar(16) not null,
    `date` date not null,
    `type` varchar(16) not null,
    primary key(`id`, `date`),
    constraint `fk_schedule_1` foreign key(`type`) references `temp`.`tbl_work_type`(`type`)
);
insert into tbl_work_schedule(id, date, type) values('甲', '2016-06-01', 'C');
insert into tbl_work_schedule(id, date, type) values('甲', '2016-06-02', 'A');
insert into tbl_work_schedule(id, date, type) values('甲', '2016-06-03', 'B');
insert into tbl_work_schedule(id, date, type) values('甲', '2016-06-04', 'A');
insert into tbl_work_schedule(id, date, type) values('甲', '2016-06-05', 'A');
insert into tbl_work_schedule(id, date, type) values('乙', '2016-06-01', 'C');
insert into tbl_work_schedule(id, date, type) values('乙', '2016-06-02', 'B');
insert into tbl_work_schedule(id, date, type) values('乙', '2016-06-03', 'A');
insert into tbl_work_schedule(id, date, type) values('乙', '2016-06-04', 'C');
insert into tbl_work_schedule(id, date, type) values('乙', '2016-06-05', 'B');

create table result (
    id varchar(16) not null,
    A int not null,    --统计A类工作天数
    B int not null,    --统计B类工作天数
    C int not null     --统计C类工作天数
);
insert into result(id, A, B, C) values('甲', 3, 1, 1);
insert into result(id, A, B, C) values('乙', 1, 2, 2);
select * from result;