Okay, so I have a database of zipcodes with the following schema:
Then, a list of high schools with the following schema:
I have the query to pull all schools by coordinates(longitude and latitude) with a 30mile radius. But what I am having trouble with is pulling a list of school in a 30 mile radius by inputting a central zipcode. Any ideas, on how I could do this without having two separate queries??