select DistricT_ID, Academic_Year_Id, count(*)
from rpt_Student_Course_Schedule
where 1=1
and Primary_Teacher_List IS NOT NULL
and Academic_Year_Id = 2018
group by Academic_Year_Id, District_Id
ORDER BY District_Id, Academic_Year_Id