Which statement is true regarding the above query if one of the values generated by the subquery is NULL?