Technology Course in H28895, Degree College

SELECT distinct programme,state,dist, count(*) as nos FROM college_course where programme='Technology' and state like 'degree%' and dist like 'H28895%' group by programme,state,dist0

Technology Course Levels