Minha query esta retornando um valor estranho
SELECT
p.id as id_pedido,
p.idcliente,
c.nome,
c.email,
p.datahorapedido
from Pedidos as p
LEFT join Clientes as c
on c.id=p.idcliente
ORDER by
CASE WHEN c.nome is NULL THEN 1 ELSE 0 END,
c.Nome ASC;
