gistfile1.txt

WITH first AS (
   SELECT id, (ST_Intersection(rast, rast, 0)).val
   FROM file_caolvkddzzlgmvyeofrh
   INNER JOIN file_xbwnbydpmwesokzmrcht ON ST_Intersects(rast, rast, 0)
)
SELECT id, COUNT(val), SUM(val), AVG(val), stddev(val), MIN(val), MAX(val)
FROM first
GROUP BY id;