完美服务公司提供金融服务。您需要显示pers表中joining_date从"1/1/2005"到"31/12/2005"的数据，职位应为分析员、文员或销售员。你将使用哪种选择语句？( )
select * from Pers where joining_date from '1/1/2005' to '31/12/2005', job='Analyst' or 'Clerk' or 'Salesman'
select * from Pers where joining_date between '1/1/2005' to '31/12/2005', job='Analyst' or job='Clerk' or job='Salesman'
select * from Pers where joining_date between '1/1/2005' and '31/12/2005' and (job='Analyst' or job='Clerk' or job='Salesman')
都不对
