728x90 SQL25 [SQL] Weather Observation Station 18 💻 문제 주소 : Weather Observation Station 18 | HackerRank The PADS | HackerRankQuery the name and abbreviated occupation for each person in OCCUPATIONS.www.hackerrank.com 💻 문제Consider P1(a, b) and P2(c, d) to be two points on a 2D plane.-. a happens to equal the minimum value in Northern Latitude (LAT_N in STATION).-. b happens to equal the minimum value in Western Longitude (LONG_W in STATION)... 2024. 5. 3. [SQL] The PADS 💻 문제 주소 : The PADS | HackerRank The PADS | HackerRankQuery the name and abbreviated occupation for each person in OCCUPATIONS.www.hackerrank.com 💻 문제Generate the following two result sets: 1️⃣ Query an alphabetically ordered list of all names in OCCUPATIONS, immediately followed by the first letter of each profession as a parenthetical (i.e., enclosed in parentheses). For example, AnActorName.. 2024. 4. 30. [SQL] Weather Observation Station 5 💻 문제 주소 : Weather Observation Station 5 | HackerRank Weather Observation Station 5 | HackerRankWrite 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 lognest CITY names, as well as their respective lengths (i.e.: number of characters in the name). If there .. 2024. 4. 24. [SQL] Weather Observation Station 3 💻 문제 주소 : Weather Observation Station 3 | HackerRank Weather Observation Station 3 | HackerRank Query a list of unique CITY names with even ID numbers. www.hackerrank.com 💻 문제 Query a list of CITY names from STATION for cities that have an even ID number. Print the results in any order, but exclude duplicates from the answer. The STATION table is described as follows: Column name Type ID Number .. 2024. 3. 12. [SQL] Revising the Select Query I 💻 문제 주소 : Revising the Select Query I | HackerRank Revising the Select Query I | HackerRank Query the data for all American cities with populations larger than 100,000. www.hackerrank.com 💻 문제 Query all columns for all American cities in the CITY table with populations larger than 100000. The CountryCode for America is USA. The CITY table is described as follows: Column name Type ID Number Name .. 2024. 3. 11. 이전 1 2 3 4 5 다음 728x90 반응형
