Question
Find the name, status and yearsofservice in a table name Employees whose status is either full time or part time but yearsofservice must be at
Find the name, status and yearsofservice in a table name Employees whose status is either full time or part time but yearsofservice must be at least 25
. | ||
a) SELECT name, status, yearsofservice FROM Employees WHERE status = full time AND status = part time OR yearsofservice >= 25 | ||
b) SELECT name, status, yearsofservice FROM Employees WHERE status = full time OR status = part time OR yearsofservice >= 25 | ||
c) SELECT name, status, yearsofservice FROM Employees WHERE status = full time OR status = part time AND yearsofservice >= 25 | ||
d) SELECT name, status, yearsofservice FROM Employees WHERE status = full time AND status = part time AND yearsofservice >= 25 |
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