algorithm (114) 썸네일형 리스트형 [HackerRank] MySQL - Weather Observation Station 4 문제 Find the difference between the total number of CITY entries in the table and the number of distinct CITY entries in the table. The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude. For example, if there are three records in the table with CITY values 'New York', 'New York', 'Bengalaru', there are 2 different city names: 'New York.. [programmers] MySQL - Lv.2 동물 수 구하기 (sum, max, min) 문제 풀이 select count(*) from animal_ins; [HackerRank] MySQL - Weather Observation Station 3 문제 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: where LAT_N is the northern latitude and LONG_W is the western longitude. 풀이 select distinct city from station where id % 2 = 0; [programmers] MySQL - Lv.2 이름에 el이 들어가는 동물 찾기 (string, date) 문제 풀이 select animal_id, name from animal_ins where animal_type = 'Dog' and name like '%el%' order by name; [HackerRank] MySQL - Weather Observation Station 1 문제 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. 풀이 select city, state from station; [programmers] MySQL - Lv.2 동명 동물 수 찾기 (group by) 문제 풀이 select name, count(name) from animal_ins group by name having count(name) order by name; [HackerRank] Java - Welcome to Java! 문제 Welcome to the world of Java! In this challenge, we practice printing to stdout. The code stubs in your editor declare a Solution class and a main method. Complete the main method by copying the two lines of code below and pasting them inside the body of your main method. System.out.println("Hello, World."); System.out.println("Hello, Java."); Input Format There is no input for this challenge.. [HackerRank] MySQL - Japanese Cities' Names 문제 Query the names of all the Japanese cities in the CITY table. The COUNTRYCODE for Japan is JPN. The CITY table is described as follows: 풀이 select name from city where countrycode = 'JPN'; 이전 1 ··· 9 10 11 12 13 14 15 다음
