List of Colleges teaching B.Tech.-Bachelor of Technology Course in Arunachal Pradesh
SELECT distinct course, state,dist,count(*) as nos FROM college_course where course='B.Tech.-Bachelor of Technology' and state like 'arunachal%' and ( dist is not null AND trim(dist)<>'') group by course,state,dist2