bWhat will be the results of the following statement?

UPDATE PAYMENTS SET status $=$ 'paid'

WHERE payment$\_$id NOT IN$($

SELECT payment$\_$id FROM ACCOUNTS$\_$PAYABLE WHERE status in $(\text{'}$pending$\text{'},$ 'rejected'$)$

$)$;

Group of answer choices

Payments that are $$pending$$ or $$rejected$$ in the ACCOUNTS$\_$PAYABLE table will have their status set to $$paid$.$

Payments that are neither 'pending' nor 'rejected' in the ACCOUNTS$\_$PAYABLE table will have their status set to 'paid'.

The statement will return an error.

Nothing will happen because the nested query will always return null