solvesql - 폐쇄할 따릉이 정류소 찾기 2👉 문제 바로가기(solvesql)-- 2018년 데이터 테이블 생성WITH t_2018 AS(SELECT t1.station_id, t1.name, t1.local, CASE WHEN (COALESCE(t2.rent_count, 0) + COALESCE(t3.return_count, 0)) IS NULL THEN 0 ELSE (COALESCE(t2.rent_count, 0) + COALESCE(t3.return_count, 0)) END as 'count_18'FROM station t1LEFT OUTER JOIN (SELECT rent_station_id, COUNT(*) as rent_count FROM rental_histo..