在SQL Server中，哪种查询会显示Pers表中从2005年1月1日至2005年1月2日期间加入的雇员进行Analysts, Clerks、 Salesmen有关的数据？( )
select * from Pers where joining_date from '1/1/2005' to '1/2/2005', job='Analyst or clerk or salesman'
select * from Pers where joining_date between '1/1/2005' to '1/2/2005', job='Analyst' or job='clerk' or job='salesman'
select * from Pers where joining_date between '1/1/2005' and '1/2/2005' and (job='Analyst' or job='clerk' or job='salesman')
都不是
