List of Colleges teaching Aeronautical Engineering Course in Madhya Pradesh
SELECT distinct programme,state,dist,count(*) as nos FROM college_course where programme='Aeronautical Engineering' and state like 'madhya%' and dist is not null AND trim(dist)<>'' group by programme,state,dist2