potato's devlog

문제 https://www.hackerrank.com/challenges/weather-observation-station-5/problem 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 Query the two cities in STATION with the shortest and longest CITY names, as well as their respective lengths (i.e.: number of characters in the name)...

문제 https://www.hackerrank.com/challenges/weather-observation-station-4/problem Weather Observation Station 4 | HackerRank Find the number of duplicate CITY names in STATION. www.hackerrank.com Find the difference between the total number of CITY entries in the table and the number of distinct CITY entries in the table. where LAT_N is the northern latitude and LONG_W is the western longitude. For..

문제 https://www.hackerrank.com/challenges/weather-observation-station-3/problem 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. 정답 문제에..

문제 https://www.hackerrank.com/challenges/weather-observation-station-1/problem Weather Observation Station 1 | HackerRank Write a query to print the CITY and STATE for each attribute in the STATION table. www.hackerrank.com Query a list of CITY and STATE from the STATION table. The STATION table is described as follows: Where LAT_N is the northern latitude and LONG_W is the western longitude. 정답..

문제 https://www.hackerrank.com/challenges/japanese-cities-name/problem Japanese Cities' Names | HackerRank In this challenge, you will query a list of all the Japanese cities' names. www.hackerrank.com Query the names of all the Japanese cities in the CITY table. the COUNTRYCODE for Japanese is JPN. the CITY table is described as follows. 정답 SELECT NAME FROM CITY WHERE COUNTRYCODE LIKE 'JPN'

문제 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 Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japanese is JPN. The CITY table is described as follows. 정답 SELECT * FROM CITY WHERE COUNTRYCODE LIKE 'JPN' 아직은 너무 간단하지만... 그래도 TO..

문제 https://www.hackerrank.com/challenges/select-by-id/problem Select By ID | HackerRank Query the details of the city with ID 1661. www.hackerrank.com Query all columns for a city in CITY with the ID 1661. The CITY table is described as follows: 정답 SELECT * FROM CITY WHERE ID = 1661

문제 https://www.hackerrank.com/challenges/select-all-sql/problem Select All | HackerRank Query all columns for every row in a table. www.hackerrank.com Query all columns (attributes) for every row in the CITY table. The CITY table is described as follows: 정답 SELECT * FROM CITY 아직 기초라 너무 쉽지만... 그래도 푼게 있으니 포스팅해본다 허허.... 수요일에 있을 TOSS 쿼리 테스트 합격을 기원하며 ㅠㅠ 🙏🙏

문제링크 https://www.hackerrank.com/challenges/revising-the-select-query-2/problem Query the NAME field for all American cities in the CITY table with populations larger than 120000. The COUNTRYCODE for America is USA. The CITY table is describe as follows: 정답 SELECT NAME FROM CITY WHERE POPULATION > 120000 AND COUNTRYCODE LIKE 'USA'

참고) 이것이 취업을 위한 코딩테스트다 with 파이썬 책을 기반으로 작성된 문제와 코드입니다. 따라서 문제는 자세하게 적지 않고, 간단한 설명과 제 코드만 올리겠습니다. 문자열 재정렬 (ebook 기준 p.324) - 알파벳 대문자와 숫자 (0~9)로만 구성된 문자열이 입력으로 주어짐. - 이때 모든 알파벳을 오름차순으로 정렬하여 이어서 출력한 뒤, 그 뒤 모든 숫자의 합을 출력 - K1KA5CB7 이면 ABCKK13이 출력되어야함 ##### 입력조건 첫쨋줄에 하나의 문자열 S가 주어짐. (1