query = select school.school_id,school.tumbon,school.ampur,school.province, school.school_name,school.provice_id,school.tel,
count(selected_school_id) as count_student
from (school left join (select student_id, school_id_4 as selected_school_id,term_4,year_4 FROM v_student where concat(year_4,term_4)=
20261)as q1 on school.school_id=q1.selected_school_id)
left join school_limit on school.school_id = school_limit.school_id where school_limit.year_education= 2026 and school_limit.term= 1
group by school.school_id
having count_student > 0
order by count_student desc
โรงเรียนฝึกสอน
ตรวจสอบโรงเรียนออกทำการสอน