SQL - Hacer consultas por turnos Horas de distinto dia

("SELECT DESTINO,COUNT(DESTINO) AS TOTAL FROM parte WHERE HOUR(FECHA) BETWEEN '06:00:00' AND '14:00:00'

        GROUP BY 1 HAVING COUNT(DESTINO) >=1");

("SELECT DESTINO,COUNT(DESTINO) AS TOTAL FROM parte WHERE HOUR(FECHA) BETWEEN '14:00:00' AND '21:00:00'

        GROUP BY 1 HAVING COUNT(DESTINO) >=1");

("SELECT DESTINO,COUNT(DESTINO) AS TOTAL FROM parte WHERE HOUR(FECHA) BETWEEN '22:00:00' AND '06:00:00'

        GROUP BY 1 HAVING COUNT(DESTINO) >=1");

("SELECT DESTINO,COUNT(DESTINO) AS TOTAL FROM parte WHERE HOUR(FECHA) BETWEEN '22:00:00' AND '23:59:59'

        GROUP BY 1 HAVING COUNT(DESTINO) >=1");

("SELECT DESTINO,COUNT(DESTINO) AS TOTAL FROM parte WHERE HOUR(FECHA) BETWEEN '00:00:00' AND '05:59:59'

        GROUP BY 1 HAVING COUNT(DESTINO) >=1");

SELECT DESTINO, COUNT(*) FROM

(

SELECT DESTINO,COUNT(DESTINO) AS TOTAL FROM parte WHERE HOUR(FECHA) BETWEEN '22:00:00' AND '23:59:59'

        GROUP BY 1 HAVING COUNT(DESTINO) >=1"

UNION ALL 

SELECT DESTINO,COUNT(DESTINO) AS TOTAL FROM parte WHERE HOUR(FECHA) BETWEEN '00:00:00' AND '05:59:59'

        GROUP BY 1 HAVING COUNT(DESTINO) >=1

)  AS t

GROUP by t.DESTINO;

SELECT 	Destino

,		COUNT(distinct FECHA) AS TOTAL

FROM 	parte

WHERE

		/* si se ejecuta antes de media noche */

		FECHA BETWEEN concat(DATE(NOW()), ' 22:00:00') AND concat(DATE(NOW()), ' 23:59:59')

		/* si se ejecuta despues de media noche */

	OR 	(FECHA BETWEEN date_add(concat(DATE(NOW()), ' 22:00:00'), interval -1 day) AND concat(DATE(NOW()), ' 06:00:00'))

group by destino;

SELECT 	Destino

,		COUNT(distinct FECHA) AS TOTAL

FROM 	parte

WHERE

		/* si se ejecuta antes de media noche */

		from_unixtime(FECHA, '%Y-M%-D% %h:%i:%s') BETWEEN concat(DATE(NOW()), ' 22:00:00') AND concat(DATE(NOW()), ' 23:59:59')

		/* si se ejecuta despues de media noche */

	OR 	from_unixtime(FECHA, '%Y-M%-D% %h:%i:%s') BETWEEN date_add(concat(DATE(NOW()), ' 22:00:00'), interval -1 day) AND concat(DATE(NOW()), ' 06:00:00')

group by destino;

SELECT 	Destino

,		COUNT(distinct FECHA) AS TOTAL

FROM 	parte

WHERE

/* si se ejecuta antes de media noche */

FECHA BETWEEN UNIX_TIMESTAMP(concat(DATE(NOW()), ' 22:00:00')) AND UNIX_TIMESTAMP(concat(DATE(NOW()), ' 23:59:59'))

/* si se ejecuta despues de media noche */

OR 	FECHA BETWEEN unix_TIMESTAMP(date_add(concat(DATE(NOW()), ' 22:00:00'), interval -1 day)) AND UNIX_TIMESTAMP(concat(DATE(NOW()), ' 06:00:00'))

group by destino;

SELECT 	Destino

,		COUNT(distinct FECHA) AS TOTAL

FROM 	parte

WHERE

/* si se ejecuta antes de media noche */

FECHA BETWEEN UNIX_TIMESTAMP(concat(DATE(NOW()), ' 22:00:00')) AND UNIX_TIMESTAMP(concat(DATE(NOW()), ' 23:59:59'))

/* si se ejecuta despues de media noche */

OR 	FECHA BETWEEN unix_TIMESTAMP(date_add(concat(DATE(NOW()), ' 22:00:00'), interval -1 day)) AND UNIX_TIMESTAMP(concat(DATE(NOW()), ' 06:00:00'))

group by destino;