select *
from tt_f_schedule
WHERE
tt_f_schedule.COACH_NAME = "教练A" AND
tt_f_schedule.START_TIME >= '2016-09-01 00:00:00' AND
tt_f_schedule.END_TIME <= '2016-09-30 24:00:00'
from tt_f_schedule
WHERE
tt_f_schedule.COACH_NAME = "教练A" AND
tt_f_schedule.START_TIME >= '2016-09-01 00:00:00' AND
tt_f_schedule.END_TIME <= '2016-09-30 24:00:00'