The Manhattan Distance [NCTU Floor 23]

#Format : LIMIT s-1, t - (s - 1)
SELECT ROUND(ABS(x1 - x2) + ABS(y1 - y2), 4)
    FROM (SELECT MIN(lon) x1,  MAX(lon) x2
            FROM (SELECT*FROM citytable
                WHERE lat < 121.8 ORDER BY lat DESC LIMIT 3, 15) AS Table1) AS latTable,
         (SELECT MIN(lat) y1, MAX(lat) y2
            FROM (SELECT*FROM citytable
                WHERE lon > 25.1 ORDER BY lon ASC LIMIT 3, 15) AS Table2) AS lonTable;