Query Loop: Select ACF Fields OUTSIDE of a Repeater Where Sub-Field = "ABC"?

I’ve read a lot of ACF repeater posts on here, but I don’t believe they apply to my use case.

I have a Team Member post type with the following fields:

  1. First Name
  2. Last Name
  3. LinkedIN
  4. Employment (REPEATER)
    4a. Organization
    4b. Phone
    4c. Email

How would I set up a query that, IF a team member has an Employment repeater row at “ABC” organization, selects first name, last name, LinkedIN, as well as phone and email from the same row as “ABC” organization?

IF such a query is not possible within the Bricks UI, how can I set an “organization = ABC” condition on a div and then output first name, last name, LinkedIN, as well as phone and email from the same row as “ABC” organization WITHIN the div?

THANK YOU,

Travis