Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT Distinct CONVERT(CONCAT(CAST(A.TOTAL AS DEC(15,2)), '%'), CHAR(8)) AS Total, A.Mes, Turno
- FROM
- (SELECT (COUNT(tarefa)/46500) * 100 AS TOTAL, MONTH(IniciarTarefa) AS Mes, DATE(IniciarTarefa) AS DataInicio FROM raddb.Tarefa LEFT OUTER JOIN raddb.TipoTarefa
- ON raddb.TipoTarefa.Id = raddb.Tarefa.tarefa
- 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
- MONTH(FimTarefa) = EXTRACT(MONTH FROM CURDATE() - INTERVAL 0 MONTH)
- GROUP BY MONTH(FimTarefa), MONTH(FimTarefa), MONTH(IniciarTarefa), DATE(IniciarTarefa)) AS A LEFT OUTER JOIN raddb.sessoes ON DATE(data) = A.DataInicio
- WHERE Turno = 'M'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement