Snippet

customers who live inside 10 km radius of Times Square in New York

SELECT
  customerNumber,
  customerName,
  contactLastName,
  contactFirstName,
  phone,
  addressLine1,
  addressLine2,
  city,
  state,
  postalCode,
  country,
  salesRepEmployeeNumber,
  creditLimit
FROM
  customers
WHERE
  (
    6371 * acos(
      cos(radians (40.758896)) * cos(radians (latitude)) * cos(radians (longitude) - radians (-73.985136)) + sin(radians (40.758896)) * sin(radians (latitude))
    )
  ) <= 10;

classicmodelspublic