Getting the overlapping geometries from the same layer

query.sql

WITH temp AS (
    SELECT
      a.cartodb_id as cdbid_1,
      b.cartodb_id as cdbid_2,
      a.the_geom AS g1,
      b.the_geom AS g2
    FROM
      aois_minutes_esp a, aois_minutes_esp b
    WHERE 
      a.cartodb_id > b.cartodb_id
    AND
      a.data_range = 60
    AND
      b.data_range = 60
    AND
      ST_Intersects(a.the_geom,b.the_geom)
)

SELECT
  row_number() over () as cartodb_id,
  ST_Intersection(g1, g2) AS the_geom,   
  ST_Area(ST_Intersection(g1, g2)) AS overlap_area,
  cdbid_1,
  cdbid_2
FROM
  temp