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