Degree College 
 Pharmacy College 
 Education College 
 GHG - CIL  
select ag.*,up.*,ev.* from asian_games as ag inner JOIN university_positions as up on ag.p_id=up.s_id inner join events as ev on ev.e_id=ag.p_id where ag.institute_id=2 and ag.p_name like '%%' or ag.p_game like '%%' or up.s_name like '%%' or up.class like '%%' or ev.e_name like '%%' or ev.e_desc like '%%'
G.H.G. Khalsa College of Pharmacy
Accredited by NBA(National Board Of Accreditation)