Public feed #888323

Something

public text v1 · immutable
Raw Edit
·published 2008-02-02 00:37 UTC
rendered paste body
//Sch Hours
 SELECT 
  SUM(pr.sched_hrs) AS SchedHrs,
  pr.AgentId,
  SUM(pr.payroll_time) AS PRTime,
  LEFT(CONCAT(pr.payroll_time / pr.sched_hrs * 100), 5) AS TPS_Hours,
  qa.d_date,
  qa.d_empid,
  LEFT (CONCAT(Avg (qa.d_score)), 2) AS TPS_QA
FROM
  payroll pr

JOIN dish_qa qa
  ON qa.d_empid = pr.AgentId;

WHERE
  DATE_FORMAT(pr.SumDate, '%Y-%m-%d') BETWEEN '2008-01-28' AND '2008-01-30'
  AND DATE_FORMAT(qa.d_date, '%Y-%m-%d') = '2008-01-28'
GROUP BY
  pr.AgentId,
  LEFT(CONCAT(pr.payroll_time / pr.sched_hrs * 100), 5)