Super Query

[Jorge_Mota]

mira si te sirve esto:
select category, count(category) as total
from reportcomplete
where client_name like '%renault.%'
group by client_name, Substring(Category,1,6)