TEACHER表包括了如下的列:
ID NUMBER(9) Primary Key
LAS_NAME VARCHAR2(25)
FIRST_NAME VARCHAR2(25)
SUBJECT_ID NUMBER(9)
如果要显示每位老师的全名,同时显示每位老师所负责教授的科目(subject)号,则应该使用以下哪个查询语句
A.SELECT*FROM teacher;
B.SELECT last_name, subject_id FROM account;
C.SELECT last_name, first_name FROM account;
D.SELECT last_name, first_name, subject_id FROM account;