본문 바로가기

hackerrank23

Hacker rank Japanese Cities' Attributes 1 2 3 select * from city where countrycode='jpn' cs 2021. 10. 20.
Hacker rank Weather Observation Station 8 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 select distinct city from station where( left(city,1)='a' or left(city,1)='e' or left(city,1)='i' or left(city,1)='o' or left(city,1)='u' ) and ( right(city,1)='a' or right(city,1)='e' or right(city,1)='i' or right(city,1)='o' or right(city,1)='u' ) cs 2021. 10. 20.
Hacker rank Weather Observation Station 6 1 2 3 4 5 6 7 8 select city from station where left(city,1)='a' or left(city,1)='e' or left(city,1)='i' or left(city,1)='o' or left(city,1)='u' cs left 함수는 문자열 다루는 함수구요 left(변수명, 글자수) 변수명 의 글자수 왼쪽만큼을 return 합니다 2021. 10. 20.
Hacker rank Weather Observation Station 4 1 2 select count(city)- count(distinct city) from station cs 중복 제거 == distinct 2021. 10. 20.
Hacker rank Weather Observation Station 3 1 2 3 select distinct city from station where mod(id,2)=0 cs Line 3 이 프로그래밍언어랑 SQL의 차이죠 Python은 %이 나머지 operator이고 mysql 에서는 mod 함수를 씁니다 ^6^ 2021. 10. 20.
Hacker rank Weather Observation Station 1 1 2 select city,state from station cs 2021. 10. 20.
Hacker rank Japanese Cities' Names 1 2 3 select name from city where countrycode='JPN' cs 2021. 10. 20.
Hacker rank Select By ID 1 2 3 select * from city where id=1661 cs 2021. 10. 20.
Hacker rank Select All 1 2 select * from city cs 2021. 10. 20.
Hacker rank Revising the Select Query II 1 2 3 select name from city where population >120000 and countrycode='USA' cs 2021. 10. 20.
Hackerrank Revising the Select Query I 1 2 3 select * from city where population>100000 and countrycode='USA' cs 2021. 10. 20.