융무의 기술블로그
article thumbnail
[SQL][HackerRank] Binary Tree Nodes
Algorithm/SQL 2020. 6. 9. 12:25

https://www.hackerrank.com/challenges/binary-search-tree-1/problem?h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen Binary Tree Nodes | HackerRank Write a query to find the node type of BST ordered by the value of the node. www.hackerrank.com You are given a..

article thumbnail
[SQL][HackerRank] Employee Salaries
Algorithm/SQL 2020. 6. 9. 10:21

https://www.hackerrank.com/challenges/salary-of-employees/problem?h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen Employee Salaries | HackerRank Print the names of employees who earn more than $2000 per month and have worked at the company for less than 10 months. www.hackerrank.com ..

article thumbnail
[SQL][HackerRank] Employee Names
Algorithm/SQL 2020. 6. 9. 10:18

https://www.hackerrank.com/challenges/name-of-employees/problem?h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen Employee Names | HackerRank Print employee names. www.hackerrank.com Write a query that prints a list of employee names (i.e.: the name attribute) from the Employee table in alphabetical order. Input..

article thumbnail
[SQL][HackerRank] Higher Than 75 Marks
Algorithm/SQL 2020. 6. 9. 10:14

https://www.hackerrank.com/challenges/more-than-75-marks/problem?h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen Higher Than 75 Marks | HackerRank Query the names of students scoring higher than 75 Marks. Sort the output by the LAST three characters of each name. www.hackerrank.com Query the Name of any student in STUDENTS who scored hi..

article thumbnail
[SQL][HackerRank] Weather Observation Station 12
Algorithm/SQL 2020. 6. 9. 10:09

https://www.hackerrank.com/challenges/weather-observation-station-12/problem?h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen Weather Observation Station 12 | HackerRank Query an alphabetically ordered list of CITY names not starting and ending with vowels. www.hackerrank.com Query the list of CITY names from STATION that do not start with vowels and do not end wi..

article thumbnail
[SQL][HackerRank] Weather Observation Station 11
Algorithm/SQL 2020. 6. 9. 09:55

https://www.hackerrank.com/challenges/weather-observation-station-11/problem?h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen Weather Observation Station 11 | HackerRank Query a list of CITY names not starting or ending with vowels. www.hackerrank.com query CITY names ==> SELECT CITY from STATION table ==> FROM STATION do not start or end with vowels ==> WHERE CITY REGEXP ‘^[^aeiou]|[^aeiou..

article thumbnail
[SQL][HackerRank] Weather Observation Station 10
Algorithm/SQL 2020. 6. 9. 09:51

https://www.hackerrank.com/challenges/weather-observation-station-10/problem?h_r=next-challenge&h_v=zen Weather Observation Station 10 | HackerRank Query a list of CITY names not ending in vowels. www.hackerrank.com query CITY names ==> SELECT CITY from STATION table ==> FROM STATION do not end with vowels ==> WHERE CITY REGEXP ‘[^aeiou]$’ do not contain duplicates ==> SELECT DISTINCT CITY selec..

article thumbnail
[SQL][HackerRank] Weather Observation Station 9
Algorithm/SQL 2020. 6. 9. 09:47

https://www.hackerrank.com/challenges/weather-observation-station-9/problem Weather Observation Station 9 | HackerRank Query an alphabetically ordered list of CITY names not starting with vowels. www.hackerrank.com select DISTINCT CITY from STATION where city not like 'a%' and city not like 'e%' and city not like 'i%' and city not like 'o%' and city not like 'u%' SELECT DISTINCT CITY FROM STATIO..