List of Colleges teaching Library & Information Science Course in Punjab
SELECT distinct programme,state,dist,count(*) as nos FROM college_course where programme='Library & Information Science' and state like 'punjab%' and dist is not null AND trim(dist)<>'' group by programme,state,dist12