step5

SELECT table_name, rows_last_45_days
FROM (
    SELECT 
        table_name,
        DBMS_XMLGEN.GETXMLTYPE(
            'SELECT COUNT(*) c FROM ' || table_name || 
            ' WHERE INTERNTIMESTAMP >= SYSDATE - 45'
        ).EXTRACT('//C/text()').GETNUMBER() AS rows_last_45_days
    FROM (
        SELECT table_name
        FROM   user_tab_columns
        WHERE  UPPER(column_name) = 'INTERNTIMESTAMP'
          AND  data_type LIKE 'TIMESTAMP%'
    )
)
ORDER BY rows_last_45_days DESC NULLS LAST;