QuatoHub

{"version":1,"resource":"file:///c%3A/Users/larry/Desktop/ksx9101-express-server/routers/admin/admin.ctrl.js","entries":[{"id":"iiNc.js","timestamp":1668387377636},{"id":"Nf6l.js","timestamp":1668387521246},{"id":"HenL.js","timestamp":1668389290234},{"id":"nCK1.js","timestamp":1668389363767},{"id":"E3Kf.js","timestamp":1668389463716},{"id":"yuij.js","timestamp":1668389521030},{"id":"Z8JM.js","timestamp":1668389605756},{"id":"tcYY.js","timestamp":1668389681650},{"id":"6qZ8.js","timestamp":1668389741167},{"id":"kp3h.js","timestamp":1668389800847},{"id":"3QFZ.js","timestamp":1668390158380},{"id":"DS4m.js","timestamp":1668390191264},{"id":"3NuV.js","timestamp":1668390288175},{"id":"l0gv.js","timestamp":1668390377290},{"id":"IhZc.js","timestamp":1668390603785},{"id":"9ph0.js","timestamp":1668390666335},{"id":"K87e.js","timestamp":1668390736898},{"id":"6qIY.js","timestamp":1668391257938},{"id":"6jtg.js","timestamp":1668391331608},{"id":"eHKI.js","timestamp":1668391511782},{"id":"XQ89.js","timestamp":1668391533947},

QuatoHub

SELECT ROUND(LAT_N, 4) FROM STATION AS S
WHERE (SELECT COUNT(*) FROM STATION WHERE LAT_N < S.LAT_N) 
    = (SELECT COUNT(*) FROM STATION WHERE LAT_N > S.LAT_N);

QuatoHub

SELECT
    ROUND(SQRT(
        POWER(MAX(LAT_N)  - MIN(LAT_N),  2)
      + POWER(MAX(LONG_W) - MIN(LONG_W), 2)
    ), 4)
FROM STATION;

QuatoHub

SELECT ROUND (
  MAX(lat_n) - MIN(lat_n) 
+ MAX(long_w) - MIN(long_w), 4) 
FROM Station;

QuatoHub

SELECT ROUND(LONG_W, 4) FROM STATION 
WHERE LAT_N > 38.7780 
ORDER BY LAT_N LIMIT 1;

QuatoHub

SELECT ROUND(LAT_N, 4) FROM STATION\
WHERE LAT_N > 38.7780 
ORDER BY LAT_N LIMIT 1;

QuatoHub

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

QuatoHub

SELECT TRUNCATE(MAX(LAT_N), 4) FROM STATION WHERE LAT_N < 137.2345;

QuatoHub

SELECT TRUNCATE(SUM(LAT_N), 4) FROM STATION 
WHERE LAT_N BETWEEN 38.7880 AND 137.2345;

QuatoHub

SELECT ROUND(SUM(LAT_N), 2), ROUND(SUM(LONG_W), 2) FROM STATION;