~고군분투 인생살이~

The Report | HackerRank Write a query to generate a report containing three columns: Name, Grade and Mark. www.hackerrank.com 문제 조건 이름, 등급, 점수의 세 개의 열이 포함된 보고서를 출력하시오. 8 보다 낮은 등급을 받은 학생들의 이름은 출력하지 않습니다. 정렬 순서는 아래와 같습니다 : 등급을 기준으로 내림차순 -> 이름을 알파벳 순으로 정렬 -> 점수를 기준으로 오름차순 문제 풀이 select (case when g.grade < 8 then Null else s.name end) as name, g.grade, s.marks from students s join grades g on s.mark..

Weather Observation Station 8 | HackerRank Query CITY names that start AND end with vowels. www.hackerrank.com 문제 조건 a,e,i,o,u로 시작하면서 끝나는 city 이름을 유니크하게 출력하시오. 문제 풀이 select distinct city from station where city regexp '^[a,e,i,o,u]' and city regexp '[a,e,i,o,u]$'

Weather Observation Station 7 | HackerRank Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. www.hackerrank.com 문제 조건 끝 글자가 a,e,i,o,u를 가지는 city 이름을 유니크하게 출력하시오 문제 풀이 # solution 1 select distinct city from station where city regexp '[a,e,i,o,u]$' # solution 2 select distinct city from station where city like '%a' or city like '%e' or city like '%i' or city like '%o' or..

Weather Observation Station 6 | HackerRank Query a list of CITY names beginning with vowels (a, e, i, o, u). www.hackerrank.com 문제 조건 a,e,i,o,u로 시작되는 city의 이름을 출력하시오 문제 풀이 # solution 1 select city from station where left(city,1) in ('a','e','i','o','u') # solution 2 select city from station where substr(city,1,1) in ('a','e','i','o','u')

1. 문제 설명 Query the list of CITY names from STATION that do not end with vowels. Your result cannot contain duplicates. Input Format The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude. 2. 문제 풀이 3. 결과 SELECT DISTINCT CITY FROM STATION WHERE CITY REGEXP '[^AEIOU]$.*'

1. 문제 설명 Query the list of CITY names from STATION that do not start with vowels. Your result cannot contain duplicates. Input Format The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude. 2. 문제 풀이 3. 결과 SELECT DISTINCT CITY FROM STATION WHERE CITY REGEXP '^[^AEIOU].*'

1. 문제 설명 Query the list of CITY names from STATION which have vowels (i.e., a, e, i, o, and u) as both their first and last characters. Your result cannot contain duplicates. Input Format The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude. 2. 문제 풀이 3. 결과 SELECT DISTINCT CITY FROM STATION WHERE CITY REGEXP('^[AEIOU]') AND CITY REGEX..

1. 문제 설명 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 described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude. 2. 문제 풀이 3. 결과 SELECT DISTINCT city FROM STSATION WHERE city REGEXO '[AEIOUaeiou]$.*'