Prerequisites:
Select SQL from the navigation menu in Databricks.
Click Create → Query.
Run your query as you normally would:
SELECT
concat(pickup_zip, '-', dropoff_zip) as route,
AVG(fare_amount) as average_fare
FROM
`samples`.`nyctaxi`.`trips`
GROUP BY
1
ORDER BY
2 DESC
LIMIT 1000