SQL/코딩테스트14 [MySQL] CASE 문에서 WHEN 순서의 중요성 문제 내용 : 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 values of A, B, and.. 2024. 11. 4. [MySQL] 그룹화된 변수에 조건을 걸어 원하는 값 출력하기 문제 내용 : 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 2 space-separated integers. 해석 : 직원.. 2024. 11. 4. 이전 1 2 3 4 다음