How closely does fare follow distance?

EasyUbercorrgroup by· 10 XP

Uber's pricing team expects fares to rise with distance. A weak link in one city could mean surge pricing or a data problem there.

For completed trips, show per city the correlation between fare and distance_km.

Expected output

  • Rounded to 3 decimals; any row order

Example of the shape (made-up values):

city correlation
Lakeside 0.902

Hints, the later steps and the answer come with Pro.

Write your query here. Ctrl + Enter submits.