Eduardo Fuerte
asked on
Could you check what is preventing this MySQL query to correctly running?
Hi Experts
Could you check what is preventing this MySQL query to correctly running?
The error produced:
Thanks in advance
Could you check what is preventing this MySQL query to correctly running?
SELECT
id_reclamacao,
sise,
fk_seguradora,
nome_reclamante,
data,
case TIMESTAMPDIFF(HOUR, data, IFNULL(data_atendimento, CURRENT_TIMESTAMP))
WHEN <24 THEN 'V'
WHEN >=24 AND < 36 THEN 'A'
WHEN >=36 AND < 48 THEN 'L'
ELSE 'Ve'
END AS sla,
nome_agente,
procedencia
FROM system_reclamacao
The error produced:
Thanks in advance
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for suggestions also.