TEST2SELECT *, (select vcity_name from city where city.ncityid = university_info.city) ct, (select vstate_name from state where state.nstateid = university_info.state) st, (select rank from university_rank_nirf where university_rank_nirf.university_id = university_info.id) rank from university_info WHERE university_info.city in (2316)shikhar