ผลการดำเนินงานการจัดบริการการแพทย์ทางไกล Telemedicine/Telehealth

            SELECT 
                dev1.ampurcodefull,
                dev1.ampurname,                
                SUM(dev1.cnt_telemed_target) AS cnt_telemed_target,
                SUM(dev1.cnt_his) AS his,
                SUM(dev1.cnt_telemed_station) AS cnt_telemed_station,
                SUM(dev1.cnt_telemed_buddy) AS cnt_telemed_buddy,
                MAX(dev1.his_date) AS his_date,
                MAX(dev1.station_date) AS station_date,
                MAX(dev1.buddy_date) AS buddy_date,
                MAX(dev1.target_date) AS target_date
            FROM
            (
                SELECT
                    a.ampurcodefull, 
                    a.ampurname, 
                    h.hoscode, 
                    h.hosname, 
                    h.mcode, 
                    h.m_name, 
                    COUNT(t.cid) AS cnt_his,
                    COALESCE(tt.target_telemed, 0) AS cnt_telemed_target,
                    COALESCE(ts.cnt_telemed_station, 0) AS cnt_telemed_station,
                    COALESCE(ts2.cnt_telemed_station, 0) AS cnt_telemed_buddy,
                    MAX(t.update_at) AS his_date,
                    MAX(ts.import_date) AS station_date,
                    MAX(ts2.import_date) AS buddy_date,
                    MAX(tt.import_date) AS target_date
                FROM
                    chospital AS h
                    LEFT JOIN telemed_result AS t
                    ON 
                        h.hoscode = t.hoscode AND
                        t.date_serv BETWEEN '2025-10-01' AND '2026-09-30'
                    INNER JOIN c_ampur AS a
                    ON 
                        h.distcode = a.ampurcode AND
                        h.provcode = a.changwatcode
                    LEFT JOIN telemed_station AS ts
                    ON 
                        h.hoscode = ts.hoscode AND ts.b_year = 2569 AND ts.telemed_type = '01'
                    LEFT JOIN telemed_station AS ts2
                    ON 
                        h.hoscode = ts2.hoscode AND ts2.b_year = 2569 AND ts2.telemed_type = '02'
                    LEFT JOIN telemed_target AS tt
                    ON
                        h.hoscode = tt.hoscode AND tt.b_year = 2569
                WHERE
                    h.provcode = '53'
                GROUP BY
                    h.hoscode
            ) dev1
            GROUP BY
                dev1.ampurcodefull
            ORDER BY
                dev1.ampurcodefull ASC