Query: Tickets grouped by associated project

Query: Tickets grouped by associated project

How can I get a query that would provide me with a list of tickets, grouped by associated project, if the ticket only has an association.  Thank you.   SQL version 9117.

                  New to ADSelfService Plus?