i have this select statement, i want to display the id name and total count of no.of cases he has with the select statement i have written, i am getting two entries, i want to get one entry with this select statement results i should get ConvictName NoOfTimes