AERONAUTICAL ENGINEERING Course in Aeronautical Engineering, 27

SELECT distinct course,state,dist, count(*) as nos FROM college_course where course='AERONAUTICAL ENGINEERING' and state like '27%' and dist like 'aeronautical%' group by course,state,dist0

ALL Course Levels