aggregate + filter

Original query:

SELECT
    COUNT(*) FILTER (WHERE result_1_is_seo_account = 't') as first,
    COUNT(*) FILTER (WHERE result_2_is_seo_account = 't') as second,
    COUNT(*) FILTER (WHERE result_3_is_seo_account = 't') as third,
    COUNT(*) FILTER (WHERE result_4_is_seo_account = 't') as fourth,
    COUNT(*) total
FROM seo_search_results;

Prettified:

SELECT
  count(*) AS first,
  count(*) AS second,
  count(*) AS third,
  count(*) AS fourth,
  count(*) AS total
FROM
  "seo_search_results"