Query movimenti sopra 10000€ ultimi 2 giorni

SELECT intestatario, divisa, massimale
FROM (
    SELECT intestatario, divisa, SUM(importo) AS "massimale"
    FROM (
        SELECT DISTINCT intestatario, importo, divisa, from_timestamp(CAST(CAST(`timestamp` AS DECIMAL(30,0))/1000 AS TIMESTAMP), "yyyy-MM-dd HH:mm:ss.SSS") AS frt
        FROM contacthistory.contacts_archive
        WHERE importo IS NOT NULL) subsubtable
    WHERE date_sub(now(), 2) < frt
    GROUP BY intestatario, divisa) subtable
WHERE massimale > 10000
ORDER BY massimale DESC