Skip to content

Instantly share code, notes, and snippets.

View QuatoHub's full-sized avatar
🎯
Focusing

Hyeonjun Moon QuatoHub

🎯
Focusing
View GitHub Profile
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 A = C OR B = C THEN 'Isosceles'
ELSE 'Scalene'
END
FROM TRIANGLES
SELECT name FROM Employee
WHERE salary > 2000 AND months < 10
ORDER BY employee_id;
SELECT name FROM Employee ORDER BY name;
SELECT Name FROM STUDENTS WHERE Marks > 75
ORDER BY RIGHT(Name, 3), ID;
SELECT DISTINCT CITY FROM STATION
WHERE NOT REGEXP_LIKE(CITY, "^[aeiou]")
AND NOT REGEXP_LIKE(CITY, "[aeiou]$");
SELECT DISTINCT CITY FROM STATION
WHERE NOT REGEXP_LIKE(CITY, "^[aeiou]")
OR NOT REGEXP_LIKE(CITY, "[aeiou]$");
SELECT DISTINCT CITY FROM STATION
WHERE NOT REGEXP_LIKE(CITY, "[aeiou]$");
SELECT DISTINCT CITY FROM STATION
WHERE NOT REGEXP_LIKE(CITY, "^[aeiou]");
SELECT DISTINCT CITY FROM STATION
WHERE REGEXP_LIKE(CITY, "^[aeiou]")
AND REGEXP_LIKE(CITY, "[aeiou]$");
SELECT DISTINCT CITY FROM STATION
WHERE REGEXP_LIKE(CITY, "[aeiou]$");