Question: develop SQL queries in Microsoft access Lab Problem #11. Repeat problem #1, but only for employees of the engineering department. Lab Problem #12. Develop a
Lab Problem #11. Repeat problem #1, but only for employees of the engineering department.
Lab Problem #12. Develop a query to provide a list of all employee records having salaries more than $90,000.
Lab Problem #13. Develop a query to provide a list of all employee records where the employee's first name begins with a "J"
Lab Problem #14. Develop a query to provide a list of all employee records where the employees lastname begins with a "B" or "P" AND contains (anywhere else) an "en","on", or "ot"
Lab Problem #15. Develop a query to provide a list of all male employees where the first name is not blank, they haven't taken more than 20% of their accrued sick leave, AND EITHER the employee's salary is between $100-160K and their last name is either "Snyder" or "Boudreaux", OR their salary is > $50K but they are not in the accounting department.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
