UPDATE apt_trades_detail_api_call_yn AS T1
INNER JOIN (
-- T2: 업데이트 조건이 되는 조합을 미리 계산
SELECT
sgg_cd,
CONCAT(deal_year, LPAD(deal_month, 2, '0')) AS call_ymd
FROM
apt_trades_detail
GROUP BY
sgg_cd, deal_year, deal_month
) AS T2
ON
T1.region_code = T2.sgg_cd AND
T1.call_ymd LIKE CONCAT(T2.call_ymd, '%')
SET
T1.api_call_yn = 'Y'