select FechaProd, Count(*) as Turno1, 0 as Turno2, 0 as Turno3 from paquetes
where ( HoraProd between '06:00' and '14:15' )
group by FechaProd
union
select FechaProd, 0 as Turno1, Count(*) as Turno2, 0 as Turno3 from paquetes
where ( HoraProd between '14:15' and '22:30' )
group by FechaProd
union
select FechaProd, 0 as Turno1, 0 as Turno2, Count(*) as Turno3 from paquetes
where ( HoraProd >= '22:30' ) and ( HoraProd < '06:00' )
group by FechaProd