목록코딩테스트 (23)

HAZEL

[SQL : HackerRank/Leetcode] INNER JOIN

1. 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: >> 문제 푼 코드 select city.NAME from city INNER JOIN COUNTRY ON CITY.CountryCode = COUNTRY.CODE WHERE COUNTRY.CONTINENT = 'Africa' www.hackerrank.c..
DATA ANALYSIS/SQL 2021. 2. 12. 16:44
[SQL : GROUP BY/ where 서브쿼리 ] HackerRank: Top Earners

Top Earners >> 문제 We define an employee's total earnings to be their monthly salary x months worked, and the maximum total earnings to be the maximum total earnings for any employee in the Employee table. Write a query to find the maximum total earnings for all employees as well as the total number of employees who have maximum total earnings. Then print these values as space-separated integers...
DATA ANALYSIS/SQL 2021. 2. 12. 00:51
[SQL : HackerRank/Leetcode] CASE 문

1. Type of Triangle >> 문제 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 sides of equal length. Isosceles: It's a triangle with sides of equal length. Scalene: It's a triangle with sides of differing lengths. Not A Triangle: The given valu..
DATA ANALYSIS/SQL 2021. 2. 8. 04:39
이전 Prev 1 2 3 Next 다음