SELECT *, (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 FIND_IN_SET(college-details, all_streams) > 0