adding month as columns in SQL query
I am new in SQL query world. I would like to ask a question
I have a Query like this
SELECT
CAST(T2.AliasNAme AS NVARCHAR(100)) as 'Company',
T0.BPLName as 'Branch',
T1.SLPName as 'Sales',
T3.CardCode, T3.CardName,
COUNT(T3.CardCode) as 'Total'
FROM OINV T0
INNER JOIN OSLP T1 ON T0.SLPCode = T1.SLPCode
INNER JOIN OCRD T3 ON T0.CardCode = T3.CardCode
, OADM T2
WHERE CANCELED = 'N'
GROUP BY
T0.BPLName,
T3.CardName,
T3.CardCode,
T1.SLPName,
CAST(T2.AliasNAme AS NVARCHAR(100)),
T3.CardCode
ORDER BY
T1.SLPName
It will give me data about total invoice per customer made by sales person.
what I want to do is I want to add month column (jan, feb, mar,…. dec) and the month column will show total invoice per customer made by sales person for the selected months (example : sales A, Cust AA, in Jan got 5 invoice, Feb 1 invoice, Mar 10 ~)
can anyone help me how to get that result or better explain me the queries?
thank you very much your help will be greatly appreciated.