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