Setup the connection to ClickHouse demo site.

select toString(rand64()) as rnd_id, *
from tripdata
limit 100000000

ACOS(
(SIN
(RADIANS
(LOOKUP
(AVG
(
[dropoff_latitude]
),
[IsJFK]
)
)
)
*
SIN
(RADIANS
(AVG
(
[dropoff_latitude]
)
)
)
+
COS
(RADIANS
(LOOKUP
(AVG
(
[dropoff_latitude]
)
),
[IsJFK]
)
)
)
*
COS
(RADIANS
(AVG
(
[dropoff_latitude]
)
)
)
)
*
COS
(RADIANS
(AVG
(
[dropoff_longitude]
)
)
-
RADIANS
(LOOKUP
(AVG
(
[dropoff_longitude]
)
, [IsJFK]
)
)
)
)
* 3959