HeackerRank Basic Select Weather Observation Station 6 HeackerRank Basic Select Weather Observation Station 6 SELECT DISTINCT CITY FROM STATION WHERE CITY REGEXP '^[aeiouAEIOU]'; 코딩 테스트/SQL 2023.10.16
HeackerRank Weather Observation Station 5 HeackerRank Weather Observation Station 5 SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY), CITY LIMIT 1; SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY) DESC, CITY LIMIT 1; 코딩 테스트/SQL 2023.10.15
HeackerRank Weather Observation Station 4 HeackerRank Weather Observation Station 4 SELECT COUNT(*) - COUNT(DISTINCT CITY) AS Difference FROM STATION; 코딩 테스트/SQL 2023.10.14