코딩코딩코딩

SELECT salary*months AS earnings , count(*) FROM Employee GROUP BY earnings ORDER BY earnings DESC LIMIT 1;

SELECT ROUND(LONG_W, 4) FROM STATION WHERE LAT_N < 137.2345 ORDER BY LAT_N DESC LIMIT 1;

Answer SELECT name FROM students WHERE marks > 75 ORDER BY SUBSTRING(name, -3), id;

Answer SELECT name FROM employee WHERE salary >= 2000 AND months < 10 ORDER BY employee_id;

Answer SELECT name FROM employee ORDER BY name;

SELECT DISTINCT(CITY) FROM STATION WHERE CITY REGEXP "^[^aeiou]" AND CITY REGEXP "[^aeiou]$";