SQL Query List Open Incidents for all Techs

SQL Query List Open Incidents for all Techs

Trying tog et a query to count how many tickets each tech has open.

Can anyone assist with this?
              New to ADManager Plus?

                New to ADSelfService Plus?