ARCHITECTURE Course in Architecture, 57

SELECT distinct course,state,dist, count(*) as nos FROM college_course where course='ARCHITECTURE' and state like '57%' and dist like 'architecture%' group by course,state,dist0

ALL Course Levels