내 인생에도 예쁜 꽃이 피었으면 좋겠다

https://www.hackerrank.com/challenges/java-if-else/problem?isFullScreen=true Java If-Else | HackerRank Practice using if-else conditional statements! www.hackerrank.com import java.io.*; import java.math.*; import java.security.*; import java.text.*; import java.util.*; import java.util.concurrent.*; import java.util.regex.*; public class Solution { private static final Scanner scanner = new Sca..

https://www.hackerrank.com/challenges/java-stdin-and-stdout-1/problem?isFullScreen=true Java Stdin and Stdout I | HackerRank Get started with standard input and output. www.hackerrank.com import java.util.*; public class Solution { public static void main(String[] args) { Scanner scan = new Scanner(System.in); while (scan.hasNext()) { int a = scan.nextInt(); System.out.println(a); } } } Scanner ..

https://www.hackerrank.com/challenges/welcome-to-java/problem?isFullScreen=true Welcome to Java! | HackerRank Practice printing to stdout. www.hackerrank.com public class Solution { public static void main(String[] args) { /* Enter your code here. Print output to STDOUT. Your class should be named Solution. */ System.out.println("Hello, World."); System.out.println("Hello, Java."); } } 더보기 Welco..

[hackerrank] Prepare > SQL > Aggregation > African Cities [문제] Given the CITY and COUNTRY tables, query the names of all cities where the CONTINENT is 'Africa'. Note: CITY.CountryCode and COUNTRY.Code are matching key columns. Input Format The CITY and COUNTRY tables are described as follows: [MYSQL] [ORCALE] select a.name from city a inner join country b on (a.countrycode = b.code) where contin..

[hackerrank] Prepare > SQL > Aggregation > Population Census [문제] Given the CITY and COUNTRY tables, query the sum of the populations of all cities where the CONTINENT is 'Asia'. Note: CITY.CountryCode and COUNTRY.Code are matching key columns. Input Format The CITY and COUNTRY tables are described as follows: [MYSQL] [ORCALE] select sum( a.population) from city a inner join country b on (a.coun..

[hackerrank] Prepare > SQL > Aggregation > Weather Observation Station 19 [문제] Consider and to be two points on a 2D plane where are the respective minimum and maximum values of Northern Latitude (LAT_N) and are the respective minimum and maximum values of Western Longitude (LONG_W) in STATION. Query the Euclidean Distance between points and and format your answer to display decimal digits. Inpu..

[hackerrank] Prepare > SQL > Aggregation > Weather Observation Station 18 [문제] Consider and to be two points on a 2D plane. happens to equal the minimum value in Northern Latitude (LAT_N in STATION). happens to equal the minimum value in Western Longitude (LONG_W in STATION). happens to equal the maximum value in Northern Latitude (LAT_N in STATION). happens to equal the maximum value in Western..

[hackerrank] Prepare > SQL > Aggregation > Weather Observation Station 17 [문제] Query the Western Longitude (LONG_W)where the smallest Northern Latitude (LAT_N) in STATION is greater than . Round your answer to decimal places. Input Format The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude. [MYSQL] [ORCALE] select round(long_w,4) fr..

[hackerrank] Prepare > SQL > Aggregation > Weather Observation Station 16 [문제] Query the smallest Northern Latitude (LAT_N) from STATION that is greater than . Round your answer to decimal places. Input Format The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude. [MYSQL] [ORCALE] select round(lat_n,4) from ( select * from station whe..

[hackerrank] Prepare > SQL > Aggregation > Weather Observation Station 15 [문제] Query the Western Longitude (LONG_W) for the largest Northern Latitude (LAT_N) in STATION that is less than . Round your answer to decimal places. Input Format The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude. [MYSQL] [ORCALE] select round(long_w,4) fr..