How many Tardies does a student have in 1st period in a Flex School?

This query will show how many times a student has been Tardy in 1st period in a Flex School. 

TOTAL CAT STU CAR MST FTF STU.ID STU.LN STU.FN STU.GR FTF.STI CAT.AC BY STU.LN STU.FN STU.GR STU.ID FTF.STI CAT.AC IF CAT.AC = T  AND MST.SE = CAT.SE  AND CAR.SE = CAT.SE AND CAT.DT >= CAR.DS AND CAT.DT <= CAR.DE AND FTF.STI : 1