목록DATA ANALYSIS/SQL (32)

HAZEL

[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 4 Next 다음