select rs , count(*)as countnum from (select REGEXP_SUBSTR(old_address, '[^ ]+',1, 1) as rs from parking_lot where old_address like '%') a where rs is not null group by rs;


select rs , count(*)as countnum from (select REGEXP_SUBSTR(old_address, '[^ ]+',1, 2) as rs from parking_lot where old_address like '%대전광역시%') a where rs is not null group by rs;


select rs , count(*)as countnum from (select REGEXP_SUBSTR(old_address, '[^ ]+',1, 3) as rs from parking_lot where old_address like '%대전광역시 동구%') a where rs is not null group by rs;

이렇게 세가지를 mysql로 바꾸고 싶은데 어떻게 하나요