Hello,
I have a table named patients with following fields : Id, name, Creation date, referred_by
I want to create a query showing the following information
Category JAN FEB MAR APR .......
Friend 5 2 1 4
Internet 3 1 1 3
Other 6 8 2 4
The numbers are the number of new patients grouped by Category and Month
Any help please?
Thanks