以下是教师(TEACHER)表中的数据： TEACHER ID LAST_N
题型：单项选择题
问题：
以下是教师(TEACHER)表中的数据：
| TEACHER | |||
| ID | LAST_NAME | FIRST_NAME | SUBJECT_ID |
| 88 | Tsu | Ming | HST AMER |
| 70 | Smith | Ellen | HST INDIA |
| 56 | Jones | Karen | |
| 58 | Hann | Jeff | HST CURR |
| 63 | Hopewell | Mary Elizabeth | HST_RELIG |
SELECT last_name‖’, ’‖first_name
FROMteacher
WHERE subject_id!=NULL
ORDER BY last_name;
A．Tsu, Ming
B．Hann, Jeff
C．Smith, Ellen
D．不显示任何值