Routing Analysis with CARTO geocoding functions

query.sql

WITH a AS (
  SELECT * FROM mad_comm_home_centroids
),
b AS (
  SELECT * FROM mad_comm_work_centroids
)
SELECT 
	c.duration as seconds,
    c.duration/60 as minutes,
    c.length, 
    c.shape as the_geom
FROM 
    a, b, cdb_route_point_to_point(a.the_geom, b.the_geom, 'car') c
WHERE
	a.cartodb_id = b.cartodb_id