코딩테스트/해커랭크 SQL44

• [해커랭크/SQL] 8. Weather Observation Station 3 👉https://www.hackerrank.com/challenges/weather-observation-station-3/problem?isFullScreen=true Weather Observation Station 3 | HackerRank Query a list of unique CITY names with even ID numbers. www.hackerrank.com 🤔 문제 분석 1) Query a list of CITY names from STATION for cities that have an even ID number. 2) Print the results in any order, but exclude duplicates from the answer. 💡 풀이 SELECT DISTINC.. 코딩테스트/해커랭크 SQL 2023. 2. 15.

• [해커랭크/SQL] 7. Japanese Cities' Attributes 👉https://www.hackerrank.com/challenges/japanese-cities-attributes/problem Japanese Cities' Attributes | HackerRank Query the attributes of all the cities in Japan. www.hackerrank.com 🤔 문제 분석 1) Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is JPN. 💡 풀이 SELECT * FROM CITY WHERE COUNTRYCODE = "JPN" 코딩테스트/해커랭크 SQL 2023. 2. 15.

• [해커랭크/SQL] 6. Weather Observation Station 1 👉https://www.hackerrank.com/challenges/weather-observation-station-1/problem?isFullScreen=true Weather Observation Station 1 | HackerRank Write a query to print the CITY and STATE for each attribute in the STATION table. www.hackerrank.com 🤔 문제 분석 1) Query a list of CITY and STATE from the STATION table. 💡 풀이 SELECT CITY, STATE FROM STATION 코딩테스트/해커랭크 SQL 2022. 12. 11.

• [해커랭크/SQL] 5. Japanese Cities' Names 👉https://www.hackerrank.com/challenges/japanese-cities-name/problem?isFullScreen=true Japanese Cities' Names | HackerRank In this challenge, you will query a list of all the Japanese cities' names. www.hackerrank.com 🤔 문제 분석 1) Query the names of all the Japanese cities in the CITY table. 2) The COUNTRYCODE for Japan is JPN. 💡 풀이 SELECT NAME FROM CITY WHERE COUNTRYCODE = "JPN" 코딩테스트/해커랭크 SQL 2022. 12. 11.

• [해커랭크/SQL] 4. Select By ID 👉https://www.hackerrank.com/challenges/select-by-id/problem?isFullScreen=true Select By ID | HackerRank Query the details of the city with ID 1661. www.hackerrank.com 🤔 문제 분석 1) Query all columns for a city in CITY with the ID 1661. 💡 풀이 SELECT * FROM CITY WHERE ID = 1661 코딩테스트/해커랭크 SQL 2022. 12. 11.

• [해커랭크/SQL] 3. Select All 👉https://www.hackerrank.com/challenges/select-all-sql/problem?isFullScreen=true Select All | HackerRank Query all columns for every row in a table. www.hackerrank.com 🤔 문제 분석 1) Query all columns (attributes) for every row in the CITY table. 💡 풀이 SELECT * FROM CITY 코딩테스트/해커랭크 SQL 2022. 12. 11.

• [해커랭크/SQL] 2. Revising the Select Query II 👉https://www.hackerrank.com/challenges/revising-the-select-query-2/problem?isFullScreen=true Revising the Select Query II | HackerRank Query the city names for all American cities with populations larger than 120,000. www.hackerrank.com 🤔 문제 분석 1) Query the NAME field 2) for all American cities in the CITY table 3) with populations larger than 120000. 4) The CountryCode for America is USA. 💡 풀이 .. 코딩테스트/해커랭크 SQL 2022. 12. 11.

• [해커랭크/SQL] 1. Revising the Select Query I 👉https://www.hackerrank.com/challenges/revising-the-select-query/problem?isFullScreen=true Revising the Select Query I | HackerRank Query the data for all American cities with populations larger than 100,000. www.hackerrank.com 🤔 문제 분석 1) Query all columns 2) for all American cities in the CITY table 3) with populations larger than 100000. 4) The CountryCode for America is USA. 💡 풀이 SELECT * FRO.. 코딩테스트/해커랭크 SQL 2022. 12. 11.