SELECT distinct course,state,dist, count(*) as nos FROM college_course where course='Acharya-Acharya' and state like '4%' and dist like 'acharyaacharya%' group by course,state,dist0
ALL Course Levels
1
Acharya-Acharya Colleges in Acharyaacharya, 4, India