Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started