根據以下三個表格,以及以下的 SQL,給出查詢結果: SELECT SSN FROM Works_On w, Employee e WHERE w.SSN = e.SSN AND e.Salary>=25000 AND PNO IN (SELECT SSN FROM Works_On wo, Office f WHERE wo.PNO = f.PNO AND f.Name = 'Research & Development') 表格資訊: Employee 表:SSN(155, 193, 221, 229, 247)、Name(Chen, Liu, John, Nancy, Sean)、Salary(29500, 21000, 31000, 30000, 25000) Office 表:PNO(1, 2, 3)、Name(Accounting, Human Resource, Research and Development) Works_On 表:SSN(155, 193, 221, 229, 247)、PNO(1, 1, 2, 3, 3)

A229 247
B229 221
C155 247
D空集合正確答案
答案與詳解
