Type of Triangle

SELECT CASE             
            WHEN A + B > C AND B + C > A AND A + C > B THEN
                CASE 
                    WHEN A = B AND B = C THEN 'Equilateral'
                    WHEN A = B OR B = C OR A = C THEN 'Isosceles'
                    ELSE 'Scalene'
                END
            ELSE 'Not A Triangle'
        END
FROM TRIANGLES;

sql에서 if문 사용하기

The PADS

SELECT CONCAT(NAME , "(", LEFT(OCCUPATION, 1) , ")")
FROM OCCUPATIONS 
ORDER BY NAME;

SELECT "There are a total of ", count(OCCUPATION), concat(lower(occupation),"s.") 
FROM OCCUPATIONS 
GROUP BY OCCUPATION 
ORDER BY count(OCCUPATION), OCCUPATION ASC;

Occupations