solvesql - 전국 카페 주소 데이터 정제하기👉 문제 바로가기(solvesql)-- 주소(address) 컬럼값을 시도, 시군구로 나누어 조회SELECT substr(address, 1, instr(address, ' ') - 1) AS sido, substr(substr(address, instr(address, ' ') +1), 1, instr(substr(address, instr(address, ' ') +1),' ') - 1) AS sigungu, COUNT(cafe_id) as cntFROM cafesGROUP BY substr(address, 1, instr(address, ' ') - 1), substr(substr(address, instr(address, ' ') +1..