SELECT DISTINCT Eventos.Evento, Eventos.Fecha,
(SELECT COUNT(*) From Eventos V Where( V.Hora>'00:00' And V.Hora<='12:00') And V.Evento=Eventos.Evento And V.Fecha=Eventos.Fecha) AS Cuenta_1,
(SELECT COUNT(*) From Eventos V Where( V.Hora>'12:00') And V.Evento=Eventos.Evento And V.Fecha=Eventos.Fecha) AS Cuenta_2
FROM Eventos