create9

SELECT 
    table_name,
    rows_last_45_days
FROM (
    SELECT 
        utc.table_name,
        XMLTABLE(
            '/ROWSET/ROW/C/text()'
            PASSING DBMS_XMLGEN.GETXMLTYPE(
                'SELECT COUNT(*) c FROM "' || utc.table_name || 
                '" WHERE INTERNTIMESTAMP >= SYSDATE - 45'
            )
            COLUMNS rows_last_45_days NUMBER PATH '.'
        ) xt
    FROM (
        SELECT table_name
        FROM user_tab_columns
        WHERE UPPER(column_name) = 'INTERNTIMESTAMP'
          AND data_type LIKE 'TIMESTAMP%'
    ) utc
)
ORDER BY rows_last_45_days DESC NULLS LAST, table_name;