SELECT distinct programme,state,dist, count(*) as nos FROM college_course where programme='Performing Arts' and state like '142%' and dist like 'performing%' group by programme,state,dist0
Performing Arts Course Levels
Performing Arts Colleges in Performing Arts, 142, India