List of Colleges teaching METALLURGICAL AND MATERIALS ENGINEERING Course in Telangana
SELECT distinct course, state,dist,count(*) as nos FROM college_course where course='METALLURGICAL AND MATERIALS ENGINEERING' and state like 'telangana%' and ( dist is not null AND trim(dist)<>'') group by course,state,dist1