목록전체 글 (128)

Milky's note

[HackerRank](E) Weather Observation Station 7

https://www.hackerrank.com/challenges/weather-observation-station-7/problem?isFullScreen=true Weather Observation Station 7 | HackerRank Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. www.hackerrank.com [문제] Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. Your result cannot contain duplicates. Input Format The STATION table is describe..
SQL/SQL 코딩 테스트-HackerRank 2022. 3. 16. 17:07
[HackerRank](E) Weather Observation Station 6

https://www.hackerrank.com/challenges/weather-observation-station-6/problem?isFullScreen=true Weather Observation Station 6 | HackerRank Query a list of CITY names beginning with vowels (a, e, i, o, u). www.hackerrank.com [문제] Query the list of CITY names starting with vowels (i.e., a, e, i, o, or u) from STATION. Your result cannot contain duplicates. Input Format The STATION table is described..
SQL/SQL 코딩 테스트-HackerRank 2022. 3. 16. 15:24
[HackerRank](E) Weather Observation Station 5

https://www.hackerrank.com/challenges/weather-observation-station-5/problem?isFullScreen=true Weather Observation Station 5 | HackerRank Write a query to print the shortest and longest length city name along with the length of the city names. www.hackerrank.com [문제] Query the two cities in STATION with the shortest and longest CITY names, as well as their respective lengths (i.e.: number of char..
SQL/SQL 코딩 테스트-HackerRank 2022. 3. 16. 15:10
[HackerRank](E) Weather Observation Station 4

https://www.hackerrank.com/challenges/weather-observation-station-4/problem?isFullScreen=true Weather Observation Station 4 | HackerRank Find the number of duplicate CITY names in STATION. www.hackerrank.com [문제] Find the difference between the total number of CITY entries in the table and the number of distinct CITY entries in the table. The STATION table is described as follows: where LAT_N is..
SQL/SQL 코딩 테스트-HackerRank 2022. 3. 16. 14:44
Prev 1 ··· 21 22 23 24 25 26 27 ··· 32 Next