SELECT
   COUNT(*)
FROM
   ActivePrograms ap1
   INNER HASH JOIN ActivePrograms ap2
      ON ap1.state + ap1.city + ap1.school_name = ap2.state + ap2.city + ap2.school_name
      AND ap1.program = 'GTT'
      AND ap2.program = 'PTE'


SELECT
   COUNT(*)
FROM
   ActivePrograms ap
   WHERE
      EXISTS (
         SELECT *
         FROM ActivePrograms ap1
         WHERE
            ap.state + ap.city + ap.school_name = ap1.state + ap1.city + ap1.school_name
            AND ap1.program = 'GTT')
      AND EXISTS (
         SELECT *
         FROM ActivePrograms ap2
         WHERE
            ap.state + ap.city + ap.school_name = ap2.state + ap2.city + ap2.school_name
            AND ap.program = 'PTE')