WHERE NOT (city REGEXP'^[aeiouAEIOU]'OR city REGEXP'[aeiouAEIOU]$');

Query the sum of Northern Latitudes (LAT_N) from STATION having values greater than 38.7880 and less than 137.2345. Truncate your answer to 4 decimal places.

SELECT ROUND(SUM(LAT_N),4)

FROM station

WHERE LAT_N>38.7880AND LAT_N<137.2345;

Query the greatest value of the Northern Latitudes (LAT_N) from STATION that is less than 137.2345. Truncate your answer to 4 decimal places.

SELECT ROUND(LAT_N,4)

FROM station

WHERE LAT_N<137.2345

ORDER BY LAT_NDESC

LIMIT1;


Query the Name of any student in STUDENTS who scored higher than Marks. Order your output by the last three characters of each name. If two or more students both have names ending in the same last three characters (i.e.: Bobby, Robby, etc.), secondary sort them by ascending ID.