Problem Solving/HackerRank3 [ SQL ] HackerRank Basic - MySQL 답안 정리(3) Higher than 75 marks SELECT NAME FROM STUDENTS WHERE MARKS > 75 ORDER BY SUBSTRING(NAME,-3,3),ID 개념 : Substring 활용 : Substring(문자열, 시작할 자리위치, 가져올개수) Employee Names, Salaries // Names SELECT NAME FROM EMPLOYEE ORDER BY NAME; // Salaries SELECT NAME FROM EMPLOYEE WHERE SALARY > 2000 AND MONTHS < 10 ORDER BY EMPLOYEE_ID; Type of Triangle SELECT CASE WHEN A+B 문자열을 합쳐줌 개념 : substring(문자열, 시작위치, 가져올개수.. 2021. 7. 2. [ SQL ] HackerRank Basic - MySQL 답안 정리(2) - Weather Observation Station Questions Weather Observation Station 01 ~ 05 // 01 SELECT CITY, STATE FROM STATION // 02 SELECT DISTINCT CITY FROM STATION WHERE ID % 2 = 0 // 03 SELECT COUNT(CITY) - COUNT(DISTINCT CITY) FROM STATION // 04 SELECT CITY, LENGTH(CITY) FROM STATION GROUP BY CITY ORDER BY LENGTH(CITY),CITY LIMIT 1; // 05 SELECT CITY, LENGTH(CITY) FROM STATION GROUP BY CITY ORDER BY LENGTH(CITY) DESC, CITY LIMIT 1; Weather Ob.. 2021. 6. 29. [ SQL ] HackerRank Basic - MySQL 답안 정리(1) Revising the Select Query 1,2 SELECT * FROM CITY WHERE POPULATION > 100000 AND COUNTRYCODE = 'USA' SELECT NAME FROM CITY WHERE POPULATION > 120000 AND COUNTRYCODE = 'USA' Select All SELECT * FROM CITY Select By ID SELECT * FROM CITY WHERE ID = 1661 Japanese Cities' Attributes & Names SELECT * FROM CITY WHERE COUNTRYCODE = 'JPN' SELECT NAME FROM CITY WHERE COUNTRYCODE = 'JPN' 2021. 6. 29. 이전 1 다음
