CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `ATS`@`localhost` 
    SQL SECURITY DEFINER
VIEW `ATS`.`vw_rpt_dev_status_lag_time` AS
    SELECT 
        `ATS`.`dev_est_reqs_status`.`iddev_est_reqs` AS `iddev_est_reqs`,
        SUM(`ATS`.`dev_est_reqs_status`.`lag_time`) AS `lag_time`
    FROM
        `ATS`.`dev_est_reqs_status`
    WHERE
        (`ATS`.`dev_est_reqs_status`.`iddev_est_reqs` = `ATS`.`dev_est_reqs_status`.`iddev_est_reqs`)
    GROUP BY `ATS`.`dev_est_reqs_status`.`iddev_est_reqs`