I prefer this:

SELECT customerid,

customername,

count(*)...