전체 글93 [HackerRank] INNER JOIN : Asian Population 1. 문제 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: 2. 답 SELECT SUM(city.population) FROM city INNER JOIN country ON city.countrycode = country.code where country.continent = 'Asia' 3. KEY POINT INN.. 2021. 3. 15. [HackerRank] INNER JOIN : African Cities 1. 문제 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: 2. 답 SELECT city.name FROM city INNER JOIN country ON city.countrycode = country.code WHERE country.continent = 'Africa' 3. KEY POINT INNER JOIN : 양쪽 테이블에 모두 정보가.. 2021. 3. 15. [HackerRank] CASE : Type of Triangle 1. 문제 Write a query identifying the type of each record in the TRIANGLES table using its three side lengths. Output one of the following statements for each record in the table: Equilateral: It's a triangle with 3 sides of equal length. Isosceles: It's a triangle with 2 sides of equal length. Scalene: It's a triangle with 3 sides of differing lengths. Not A Triangle: The given values of A, B, an.. 2021. 3. 15. 이전 1 ··· 13 14 15 16 다음
