The JSON below is stored in a VARIANT column named V in a table named jCustRaw:

Which query will return one row per team member (stored in the teamMembers array) along with all of the attributes of each team member?