I am using the query below to return the number of customers that are labeled as A, B, C, D. When I run my query it puts A on one line, and B on another like below.
32 A Bill Smith
49 B Bill Smith
37 C Bill Smith
188 D Bill Smith
22 A Mike Jones
6 B Mike Jones
41 C Mike Jones
274 D Mike Jones
Ideally I would like it to be like
32 49 37 188 Bill Smith
22 6 41 274 Mike Jones
I don't have any idea how to approach this.
select count(*) as Total, hi_customerratingname as Rating,owneridname as SE
on (filteredaccount.ownerid =filteredsystemuser.systemuserid
and filteredsystemuser.title = 'Sales Engineer')
Where hi_customerratingname in ('a', 'b', 'c', 'd')
and filteredaccount.statuscodename = 'active'
group by owneridname, hi_customerratingname
order by owneridname asc