목록2024/06/04 (1)
짜리몽땅 매거진
[SQL] solvesql 코딩테스트 연습10
문제1. 폐쇄할 따릉이 정류소 찾기 1출처 : solvesql 연습문제문제 정보 : 난이도 5 / 정답률 52.50%https://solvesql.com/problems/find-unnecessary-station-1/ https://solvesql.com/problems/find-unnecessary-station-1/ solvesql.com 정답 쿼리select a.station_id, a.namefrom station ajoin station b on a.station_id != b.station_idwhere a.updated_at = 5 문제 해설 1. 주요 포인트 1 - 불일치 조건 joinjoin station b on a.station_id != b.station_id 반경 내의 다른 따..
Data/SQL
2024. 6. 4. 18:21