select case suma incorrecta

[mortiprogramador]

Saludo


Pues yo propongo una subconsulta sobre la consulta inicial,
es decir, algo así:

Código MySQL:

SELECT 
pa.id_personal ID, CONCAT(nombre, ' ', apellido) Nombre, SUM(pa.Horas) 'Horas totales', precio_hora 'Precio/Hora'
FROM 
(
    SELECT 
    id_personal, 
    CASE
        WHEN (salida >= '2018-01-01 00:00:00' AND salida <= '2018-01-31 23:59:59') 
            THEN time_format(sec_to_time(timestampdiff(second, entrada, salida)), '%H:%i')
          WHEN (salida > '2018-01-31 23:59:59') 
            THEN time_format(sec_to_time(timestampdiff(second, entrada, '2018-02-01 00:00:00')), '%H:%i')
          WHEN (salida = 0 ) 
            THEN time_format(sec_to_time(timestampdiff(second, entrada, now())), '%H:%i')
    END Horas
        FROM personal_asistencia
    WHERE datetime1 BETWEEN '2018-01-01 00:00:00' AND '2018-01-31 23:59:59'
) pa
INNER JOIN personal ON pa.id_personal = personal.id
INNER JOIN personal_precio_hora ON personal.id = personal_precio_hora.id_personal
GROUP BY pa.id_personal;