select cho.cho_id, cho.cho_name, cho.cho_address, cho.cho_city, cho.cho_state, cho.cho_zipcode, from tbl_CHO_Operators cho where cho.cho_segmentId = 2 and cho.cho_type = 'O' and ( select count(*) from tbl_CHO_Operators choU where cho.cho_id = choU.cho_parentCo ) < 4