[MySQL] Hacker Rank 문제 연습 5

Employ Salaries (Basic Select)

• 

제출한 쿼리 :

SELECT NAME
FROM EMPLOYEE
WHERE SALARY > 2000
    AND MONTHS < 10
ORDER BY EMPLOYEE_ID ASC;

---

Type of Triangle (Advanced Select)

• 

제출한 쿼리 :

SELECT CASE WHEN (A = B AND B = C) THEN 'Equilateral'
            WHEN ((A + B <= C) OR (B + C <= A) OR (A + C <= B)) THEN 'Not A Triangle'
            WHEN ((A = B) OR (B = C) OR (A = C)) THEN 'Isosceles'
       ELSE 'Scalene'
       END AS triangle_type
FROM TRIANGLES;

---

The PADS (Advanced Select)

• 

제출한 쿼리 :

SELECT CONCAT(Name, '(', LEFT(Occupation, 1), ')') AS Name_Occupation
FROM OCCUPATIONS
ORDER BY Name_Occupation;

SELECT  CONCAT('There are a total of ', COUNT(Occupation), ' ', LOWER(Occupation), 's.') AS Occupation_Count
FROM OCCUPATIONS
GROUP BY Occupation
ORDER BY COUNT(Occupation), Occupation;

---

Revising Aggregations - The Count Function (Aggregation)

• 

제출한 쿼리 :

SELECT COUNT(NAME)
FROM CITY
WHERE POPULATION > 100000

---

Revising Aggregations - The Sum Function (Aggregation)

• 

제출한 쿼리 :

SELECT SUM(POPULATION)
FROM CITY
WHERE DISTRICT = 'California'

---