코딩테스트/해커랭크 SQL44

• [해커랭크/SQL] 20. Employee Salaries 👉 https://www.hackerrank.com/challenges/salary-of-employees/problem?isFullScreen=true 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 🤔 문제 분석 1) Write a query that prints a list of employee names (i.e.: the name attribute) for employees in Employee having a salary greater tha.. 코딩테스트/해커랭크 SQL 2023. 2. 22.

• [해커랭크/SQL] 19. Employee Names 👉 https://www.hackerrank.com/challenges/name-of-employees/problem?isFullScreen=true Employee Names | HackerRank Print employee names. www.hackerrank.com 🤔 문제 분석 1) Write a query that prints a list of employee names (i.e.: the name attribute) from the Employee table in alphabetical order. 💡 풀이 SELECT name FROM Employee ORDER BY name 코딩테스트/해커랭크 SQL 2023. 2. 22.

• [해커랭크/SQL] 18. Higher Than 75 Marks 👉 https://www.hackerrank.com/challenges/more-than-75-marks/problem?isFullScreen=true 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 🤔 문제 분석 1) Query the Name of any student in STUDENTS who scored higher than Marks. 2) Order your output by the last three characters of each na.. 코딩테스트/해커랭크 SQL 2023. 2. 22.

• [해커랭크/SQL] 17. Weather Observation Station 12 (REGEXP) 👉 https://www.hackerrank.com/challenges/weather-observation-station-12/problem?isFullScreen=true&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 🤔 문제 분석 1) Query the list of CITY names from STATION that do not start with vowels and do not en.. 코딩테스트/해커랭크 SQL 2023. 2. 21.

• [해커랭크/SQL] 16. Weather Observation Station 11 (REGEXP) 👉 https://www.hackerrank.com/challenges/weather-observation-station-11/problem?isFullScreen=true&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 🤔 문제 분석 1) Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. 2) Your result cannot contain d.. 코딩테스트/해커랭크 SQL 2023. 2. 21.

• [해커랭크/SQL] 15. Weather Observation Station 10 (REGEXP) 👉 https://www.hackerrank.com/challenges/weather-observation-station-10/problem?isFullScreen=true Weather Observation Station 10 | HackerRank Query a list of CITY names not ending in vowels. www.hackerrank.com 🤔 문제 분석 1) Query the list of CITY names from STATION that do not end with vowels. Your result cannot contain duplicates. 💡 풀이 SELECT DISTINCT CITY FROM STATION WHERE CITY REGEXP "[^a|e|i|o|.. 코딩테스트/해커랭크 SQL 2023. 2. 21.

• [해커랭크/SQL] 14. Weather Observation Station 9 (REGEXP) 👉 https://www.hackerrank.com/challenges/weather-observation-station-9/problem?isFullScreen=true&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen Weather Observation Station 9 | HackerRank Query an alphabetically ordered list of CITY names not starting with vowels. www.hackerrank.com 🤔 문제 분석 1) Query the list of CITY names from STATION that do not start with vowels. Your result cannot contai.. 코딩테스트/해커랭크 SQL 2023. 2. 20.

• [해커랭크/SQL] 13. Weather Observation Station 8 (REGEXP) 👉 https://www.hackerrank.com/challenges/weather-observation-station-8/problem?isFullScreen=true&h_r=next-challenge&h_v=zen Weather Observation Station 8 | HackerRank Query CITY names that start AND end with vowels. www.hackerrank.com 🤔 문제 분석 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.. 코딩테스트/해커랭크 SQL 2023. 2. 20.

• [해커랭크/SQL] 12. 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 🤔 문제 분석 1) Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. Your result cannot contain duplicates. 💡 풀이 SELECT DISTINCT CITY FROM STA.. 코딩테스트/해커랭크 SQL 2023. 2. 20.

• [해커랭크/SQL] 11. 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 🤔 문제 분석 1) Query the list of CITY names starting with vowels (i.e., a, e, i, o, or u) from STATION. Your result cannot contain duplicates. 💡 풀이 SELECT CITY FROM STATION WHERE.. 코딩테스트/해커랭크 SQL 2023. 2. 15.

• [해커랭크/SQL] 10. 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 🤔 문제 분석 1) Query the two cities in STATION with the shortest and longest CITY names, as well as their respective lengths (i.e.: number.. 코딩테스트/해커랭크 SQL 2023. 2. 15.

• [해커랭크/SQL] 9. 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 🤔 문제 분석 1) Find the difference between the total number of CITY entries in the table and the number of distinct CITY entries in the table. 💡 풀이 SELECT COUNT(CITY) - COUNT(DISTINCT CITY) FRO.. 코딩테스트/해커랭크 SQL 2023. 2. 15.