List of Colleges teaching B.S.Course-Bachelor of Science (Physician Assistant and Emergency & Trauma Care Management) Course in Andhra Pradesh
SELECT distinct course, state,dist,count(*) as nos FROM college_course where course='B.S.Course-Bachelor of Science (Physician Assistant and Emergency & Trauma Care Management)' and state like 'andhra%' and ( dist is not null AND trim(dist)<>'') group by course,state,dist1