Home Forums SQL Server 2005 SQL Server Newbies query to find average age and percentage of patients with something RE: query to find average age and percentage of patients with something
prb88
SSC-Addicted
Points: 409
More actions
May 9, 2013 at 4:44 am
#1613703
ive added the group by but it results to this
no of operations
1
2
5
7
when i need it to result like this:
Consultant name No. of operations
Dr Smith 3
Dr Bloggs 5
Dr Doe 20