query13.sql

/*
    Which station is furthest from Meyerson Hall?

    Your query should return only one line, and only give the station id
    (station_id), station name (station_name), and distance (distance) from
    Meyerson Hall, rounded to the nearest 50 meters.
*/

-- Enter your SQL query here
select
  id as station_id,
  name as station_name,
  (round(
     st_distance(
       geog,
       st_setsrid(st_makepoint(-75.192584, 39.952415), 4326)::geography
     ) / 50.0
   ) * 50)::int as distance
from indego.station_statuses
order by st_distance(
           geog,
           st_setsrid(st_makepoint(-75.192584, 39.952415), 4326)::geography
         ) desc
limit 1;