WITH count_loaded_tasks AS (SELECT count(DISTINCT account_id), task_id
                            FROM report_dimloaderlog
                            WHERE dimension = 'geo' AND event IN ('written', 'written_no_records')
                            GROUP BY task_id
    ),

    count_all_tasks AS (SELECT count(DISTINCT account_id), task_id
                        FROM report_dimloaderlog
                        WHERE dimension = 'geo'
                        GROUP BY task_id
    )

SELECT max(report_dimloaderlog.timestamp) date,
       report_dimloaderlog.task_id,
       count_loaded_tasks.count written_accounts, count_all_tasks.count all_accounts,
       (count_loaded_tasks.count::float / count_all_tasks.count::float * 100) percent
FROM report_dimloaderlog
JOIN count_loaded_tasks ON report_dimloaderlog.task_id = count_loaded_tasks.task_id
JOIN count_all_tasks ON report_dimloaderlog.task_id = count_all_tasks.task_id
GROUP BY report_dimloaderlog.task_id, written_accounts, all_accounts, percent
ORDER BY date DESC