Advertisement
Guest User

Untitled

a guest
Jul 23rd, 2019
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. SELECT Distinct CONVERT(CONCAT(CAST(A.TOTAL AS DEC(15,2)), '%'), CHAR(8)) AS Total, A.Mes, Turno
  2.  
  3. FROM
  4. (SELECT (COUNT(tarefa)/46500) * 100 AS TOTAL, MONTH(IniciarTarefa) AS Mes, DATE(IniciarTarefa) AS DataInicio FROM raddb.Tarefa LEFT OUTER JOIN raddb.TipoTarefa
  5.  
  6. ON raddb.TipoTarefa.Id = raddb.Tarefa.tarefa
  7.  
  8. WHERE TipoTarefa IN ('4') AND DATE_FORMAT(IniciarTarefa, '%H:%i:%S') >= '07:00:00' AND DATE_FORMAT(FimTarefa, '%H:%i:%S') <= '14:00:00' AND
  9. MONTH(FimTarefa) = EXTRACT(MONTH FROM CURDATE() - INTERVAL 0 MONTH)
  10.  
  11. GROUP BY MONTH(FimTarefa), MONTH(FimTarefa), MONTH(IniciarTarefa), DATE(IniciarTarefa)) AS A LEFT OUTER JOIN raddb.sessoes ON DATE(data) = A.DataInicio
  12.  
  13. WHERE Turno = 'M'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement