SELECT
       hr.lname                              AS Last_Name,
       hr.fname                              AS First_Name,
       SUM(pr.payroll_time)                  AS SumOfpayroll_time,
       hr.max_hours                          AS max_hours,
       LEFT (CONCAT(pr.payroll_time /
                    pr.max_hours * 100), 2)  AS TPS_Hours,
       LEFT (CONCAT(AVG(qa.d_score)), 2)     AS TPS_QA,
       SUM(   up.hbo
            + up.starz
            + up.showtime
            + up.cinemax)                     AS CountOfCampaign
  FROM
           echostar.UPGRADES AS up
      JOIN ecreek.dish_qa    AS qa 
      JOIN ecreek.agent_hr   AS hr
      JOIN ecreek.payroll    AS pr ON (     pr.AgentId = hr.AgentID
                                        AND pr.AgentId = qa.d_empid
                                        AND pr.SumDate = qa.d_date
                                        AND pr.AgentID = up.AgentID )
 WHERE 1 = 1
   AND DATE_FORMAT(pr.SumDate, '%Y-%m-%d')
        BETWEEN '$date2' AND '$date1'
   AND up.`timestamp`
        BETWEEN '$date2' AND '$date1'
 GROUP BY hr.lname,
         hr.fname
LIMIT 100;