Question:Which query will display data from the Pers table relating to Analysts, Clerks and Salesmen who joined between 1/1/2005 and 1/2/2005 ?
A select * from Pers where joining_date from '1/1/2005' to '1/2/2005', job='Analyst' or 'Clerk' or 'Salesman'
B select * from Pers where joining_date between '1/1/2005' to '1/2/2005', job='Analyst' or job='Clerk' or job='Salesman'
C select * from Pers where joining_date between '1/1/2005' and '1/2/2005' and (job='Analyst' or 'Clerk' or 'Salesman')
D None of these above
+ AnswerD
+ Report