Looking for some help with a repeater using an advanced query using ACF.

I’ve got two custom post types: Product, Vendor

Vendor has a sponsored field.
Product has a relationship field connected to Vendor

I am trying to sort the Product Archive loop by the sponsored field, so that Vendors that are sponsored have their products show at the top of the list.

I can’t for the life of me figure out who that query should be written. It’s been like 3 hours of attempting everything to no avail!