Observe the following query and choose the correct option.

• A. The query is syntactically wrong
• B. The query gives all the possible student names where a finite value exists for ID
• C. The query gives the names of the students that have a null ID and it also excludes identical names
• D. The query gives the student names where a finite value exists for ID and it excludes identical names