SQL Test *

SELECT  COUNT(ffHistory.ID) as qty, ffStation.DESCRIPTION
        FROM  ffHistory
        join ffStation
        ON ffStation.ID=ffHistory.ID
        WHERE ffHistory.EnterTime BETWEEN '2019-12-09T07:00:00' and GETDATE()
        group by ffStation.DESCRIPTION