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_5 as selected_school_id,term_5,year_5 FROM v_student where concat(year_5,term_5)= 20252)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= 2025 and school_limit.term= 1 group by school.school_id having count_student > 0 order by count_student desc