SELECT distinct course,state,dist, count(*) as nos FROM college_course where course='AGRICULTURE ENGINEERING' and state like 'courses%' and dist like 'C1%' group by course,state,dist0
ALL Course Levels
1
AGRICULTURE ENGINEERING Colleges in C1, Courses, India