algorithm (114) 썸네일형 리스트형 [HackerRank] MySQL - Japanese Cities' Attributes 문제 Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is JPN. The CITY table is described as follows: 풀이 select * from city where countrycode = 'JPN'; [programmers] MySQL - Lv.2 최솟값 구하기 (sum, max, min) 문제 풀이 select datetime from animal_ins order by datetime limit 1; 위처럼 코드를 작성해도 실행에는 문제 없지만 출제 의도와 맞는 답안은 아래 코드이다. select min(datetime) from animal_ins; [programmers] MySQL - Lv.2 루시와 엘라 찾기 (string, date) 문제 풀이 select animal_id, name, sex_upon_intake from animal_ins where name in ('Lucy', 'Ella', 'Pickle', 'Rogan', 'Savrina', 'Mitty'); [HackerRank] MySQL - Select By ID 문제 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; [programmers] MySQL - Lv.2 고양이와 개는 몇 마리 있을까 문제 풀이 select animal_type, count(animal_type) from animal_ins group by animal_type order by animal_type; [HackerRank] MySQL - Select All 문제 Query all columns (attributes) for every row in the CITY table. The CITY table is described as follows: 풀이 select * from city; [HackerRank] MySQL - Revising the Select Query Ⅱ 문제 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 described as follows: 풀이 select name from city where population > 120000 and countrycode = 'USA'; [programmers] MySQL - Lv.1 상위 n개 레코드 (select) 문제 풀이 select name from animal_ins order by datetime limit 1; 이전 1 ··· 10 11 12 13 14 15 다음
