Mechanical Engineering Course in Chitrakoot, Uttar Pradesh
SELECT distinct programme,state,dist, count(*) as nos FROM college_course where programme='Mechanical Engineering' and state like 'uttar%' and dist like 'chitrakoot%' group by programme,state,dist1