Method 1: SELECT count(*) total, SUM(case when trim(last_name) like 'a%' then 1 else 0 end) A, SUM(case when trim(last_name) like 'b%' then 1 else 0 end) B, SUM(case when trim(last_name) like 'c%' then 1 else 0 end) C, SUM(case when trim(last_name) like 'd%' then 1 else 0 end) D, SUM(case when trim(last_name) like 'e%' then 1 else 0 end) E, SUM(case when trim(last_name) like 'f%' then 1 else 0 end) F, SUM(case when trim(last_name) like 'g%' then 1 else 0 end) G, SUM(case when trim(last_name) like 'h%' then 1 else 0 end) H, SUM(case when trim(last_name) like 'i%' then 1 else 0 end) I, SUM(case when trim(last_name) like 'j%' then 1 else 0 end) J, SUM(case when trim(last_name) like 'k%' then 1 else 0 end) K, SUM(case when trim(last_name) like 'l%' then 1 else 0 end) L, SUM(case when trim(last_name) like 'm%' then 1 e