Here's the portion of my table that I want to select from:
select id, actor_id, actor_display_name, posted_time, display_name, geo_coords_lat, geo_coords_lon, location_name, posted_day from verizon where posted_day BETWEEN '2014-03-01' and '2014-03-05'
I want that to be my nested query. How do I grab from that inner select a range of geo_coords_lon and geo_coords_lat?
In other words, I want to select from my inner select those rows that are within a given latitude and longitude range.
BTW: I have tried to create a temporary table and while that approach does work, I'm trying to avoid a situation where I'm "writing" anything in that it takes more time than a select statement. I just need that select statement to be limited to the subquery that I've written.
What do you think?