CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `aerion`@`localhost` 
    SQL SECURITY DEFINER
VIEW `aerion`.`vw_month_att_emp_comp` AS
    SELECT 
        `aerion`.`rpt_year_month_attrition`.`month` AS `month`,
        SUM(`aerion`.`rpt_year_month_attrition`.`started`) AS `started`,
        SUM(`aerion`.`rpt_year_month_attrition`.`ended`) AS `ended`,
        SUM(`aerion`.`rpt_year_month_attrition`.`comp_started`) AS `comp_started`,
        SUM(`aerion`.`rpt_year_month_attrition`.`comp_ended`) AS `comp_ended`
    FROM
        `aerion`.`rpt_year_month_attrition`
    GROUP BY `aerion`.`rpt_year_month_attrition`.`month`
    ORDER BY `aerion`.`rpt_year_month_attrition`.`month`