Comment by thomasdziedzic

  select this, count(*) from that group by 1