Adding individual values to a count query <p>I have the query below that returns a count of a number of tickets. I also want the query to return the individual ticket numbers in the count. This is the query:</p> <pre><code>;WITH CTE AS ( select SR_Service_RecID from SR_Audit where Audit_Text like 'Ticket status has been changed from % to "Internal"%' OR Audit_Text like 'Ticket status has been changed from % to "Closed"%' OR Audit_Text like 'Ticket status has been changed from % to "First Contact Resolution"%' ) SELECT Board_Name, COUNT(DISTINCT A.SR_Service_RecID) AS 'Re-Opened Tickets' FROM CTE JOIN SR_Audit A ON CTE.SR_Service_RecID = A.SR_Service_RecID JOIN v_rpt_service vsrv ON vsrv.TicketNbr = A.SR_Service_RecID WHERE Audit_Text LIKE 'Ticket status has been changed from%"Re-Opened"%' AND vsrv.company_name &lt;&gt; 'XYZ Test Company' AND vsrv.date_entered BETWEEN @StartDate AND @EndDate AND Board_Name in (@BoardName) GROUP BY Board_Name </code></pre> <p>It returns:</p> <pre><code>Board Name Count IT Services 4 </code></pre> <p>I want it to return this:</p> <pre><code> Board Name Count Ticket Number IT Services 4 12346 IT Services 4 12445 IT Services 4 56345 IT Services 4 12384 </code></pre> <p>How can I add the ticket numbers to the result?</p>