列出“计算机系”与“电子工程系”不同职称的教师的TNAME和PROFESSION。

参考答案:

SELECT TNAMEPROFESSION FROM TEACHER WHERE DEPARTMENT="计算机系"AND PROFESSION NOT IN(SELECT PROFESSION FROM TEACHER WHERE DEPARTMENT="电子工程系")；SELECT TNAME，PROFESSION FROM TEACHER WHERE DEPARTMENT="计算机系"AND PROFESSION NOT IN(SELECT PROFESSION FROM TEACHE