CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `aerion`@`localhost` 
    SQL SECURITY DEFINER
VIEW `vw_emp_hrs5` AS
    SELECT 
        `vw_row_emp_hrs3`.`emp_id` AS `emp_id`,
        `vw_row_emp_hrs3`.`firstname` AS `firstname`,
        `vw_row_emp_hrs3`.`comp_id` AS `comp_id`,
        `vw_row_emp_hrs3`.`lastname` AS `lastname`,
        `vw_row_emp_hrs3`.`yr_hours` AS `yr_hours`,
        SUM(`vw_row_emp_hrs3`.`Jan`) AS `Jan`,
        SUM(`vw_row_emp_hrs3`.`Feb`) AS `Feb`,
        SUM(`vw_row_emp_hrs3`.`Mar`) AS `Mar`,
        SUM(`vw_row_emp_hrs3`.`Apr`) AS `Apr`,
        SUM(`vw_row_emp_hrs3`.`May`) AS `May`,
        SUM(`vw_row_emp_hrs3`.`Jun`) AS `Jun`,
        SUM(`vw_row_emp_hrs3`.`Jul`) AS `Jul`,
        SUM(`vw_row_emp_hrs3`.`Aug`) AS `Aug`,
        SUM(`vw_row_emp_hrs3`.`Sep`) AS `Sep`,
        SUM(`vw_row_emp_hrs3`.`Oct`) AS `Oct`,
        SUM(`vw_row_emp_hrs3`.`Nov`) AS `Nov`,
        SUM(`vw_row_emp_hrs3`.`Dec_h`) AS `Dec_h`
    FROM
        `vw_row_emp_hrs3`
    GROUP BY `vw_row_emp_hrs3`.`emp_id` , `vw_row_emp_hrs3`.`yr_hours` , `vw_row_emp_hrs3`.`comp_id`