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

  • 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