Get the routes nearby whole foods, note the location comparison part is total garbage

shitty_nearby_routes.sql

SELECT * FROM trips,
(
    SELECT * FROM stop_times,
    (
        SELECT * FROM stops
        WHERE stop_lat > 30.260650 AND stop_lat < 30.280650
        AND stop_lon < -97.743562 AND stop_lon > -97.763562
    ) as nearby_stops
    WHERE stop_times.stop_id = nearby_stops.stop_id
    GROUP BY trip_id 
) as nearby_trips
WHERE trips.trip_id = nearby_trips.trip_id
GROUP BY route_id