Question: 12 (1 point) Using PROP2 database, to get a list of all male staff with a supervisor or assistant position. Sample result is listed below:

12 (1 point) Using PROP2 database, to get a list of all male staff with a supervisor or assistant position. Sample result is listed below: STAFF S POSITION ----- - --------------- SA5 M Assistant SA10 M Supervisor SA8 M Assistant SG16 M Supervisor Which one of the following option will give us a correct where statement A: where sex ='M' or (Position='Supervisor' or position='Assistant') B: where sex ='M' or Position in ('Supervisor', ,'Assistant') C: where sex like 'M' or Position in ('Supervisor', ,'Assistant') D: A, B, and C are correct Question 12 options: A B C D

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!