peppapig13132/hackerrank-mysql.md

## hackerrank-mysql.md

      
    Raw
  

              hackerrank-mysql.md
            
          
    06/29/2024
Query the total population of all cities in CITY where District is California.
SELECT SUM(POPULATION)
FROM CITY
WHERE District = 'California';

06/22/2024
SELECT
    CASE
        WHEN A + B <= C OR A + C <= B OR B + C <= A THEN 'Not A Triangle'
        WHEN A = B AND B = C THEN 'Equilateral'
        WHEN A = B OR B = C OR A = C THEN 'Isosceles'
        ELSE 'Scalene'
    END AS TriangleType
FROM TRIANGLES;