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