STUDENT表结构:
ID NUMBER(9) FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25)
SELECT * FROM student WHERE id =
(SELECT id FROM student
WHERE UPPER(first_name) = ‘KATE’ AND UPPER(last_name) ='HENRY');
A、The FIRST_NAME and LAST_NAME values in the database are in lowercase.
B、There is more than one student named Kate Henry.
C、There is more than one student named Kate.
D、There are no students named Kate Henry.
B