potato's devlog

문제 https://www.hackerrank.com/challenges/weather-observation-station-10/problem Weather Observation Station 10 | HackerRank Query a list of CITY names not ending in vowels. www.hackerrank.com Query the list of CITY names from STATION that do not end with vowels. Your result cannot contain duplicates. Input Format The STATION table is described as follows: where LAT_N is the northern latitude and..

문제 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 Query the list of CITY names from STATION that do not start with vowels. Your result cannot contain duplicates. Input Format The STATION table is described as follows: where LAT_N ..

문제 https://www.hackerrank.com/challenges/weather-observation-station-8/problem Weather Observation Station 8 | HackerRank Query CITY names that start AND end with vowels. www.hackerrank.com 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 duplicates. Input Format The STATION table is describe..

문제 https://www.hackerrank.com/challenges/weather-observation-station-7/problem Weather Observation Station 7 | HackerRank Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. www.hackerrank.com Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. Your result cannot contain duplicates. Input Format The STATION table is described as follows: where ..

문제 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/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 쿼리 테스트 합격을 기원하며 ㅠㅠ 🙏🙏

programmers.co.kr/learn/courses/30/lessons/62284 코딩테스트 연습 - 우유와 요거트가 담긴 장바구니 CART_PRODUCTS 테이블은 장바구니에 담긴 상품 정보를 담은 테이블입니다. CART_PRODUCTS 테이블의 구조는 다음과 같으며, ID, CART_ID, NAME, PRICE는 각각 테이블의 아이디, 장바구니의 아이디, 상품 종류, 가 programmers.co.kr 문제 CART_PRODUCTS 테이블은 장바구니에 담긴 상품 정보를 담은 테이블입니다. CART_PRODUCTS 테이블의 구조는 다음과 같으며, ID, CART_ID, NAME, PRICE는 각각 테이블의 아이디, 장바구니의 아이디, 상품 종류, 가격을 나타냅니다. 데이터 분석 팀에서는 우유(Mi..