Requirement: Get a list of store locations within a mileage range.
Setup: A Location content type with fields for the address, zipcode, city and state. Client wanted them separately so using the Location or Geolocation would not have done much for us. Though I only spent less than 30 minutes with each of these to see what they had to offer for what was needed.
Challenge: Perform a mathematical formula in Views using the hook_views_query_alter.