Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
1. Use Employees table a) To display First_Name, Salary and Department_id ofall the employees, whose Department_id is either 50 or 80 and the salary is more than 5000 or the total letters of the first_name should be more than or equal to 6 and the First_Name should contain letter "e" at the second position from the last. b) When do we use the SQL Wildcard Characters and "%" with an example each?

1. Use Employees table a) To display First_Name, Salary and Department_id ofall the employees, whose Department_id is either 50 or 80 and the salary is more than 5000 or the total letters of the first_name should be more than or equal to 6 and the First_Name should contain letter "e" at the second position from the last. b) When do we use the SQL Wildcard Characters and "%" with an example each?

Database Systems: Design, Implementation, & Management
Database Systems: Design, Implementation, & Management
11th Edition
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Chapter7: Introduction To Structured Query Language (sql)
Section: Chapter Questions
Problem 12P: Write the SQL code that will change the PROJ_NUM to 14 for employees who were hired before January...
See similar textbooks
icon
Related questions
Question

One of the construction company has a huge database to handle their employees’ details.
Most of the details regarding the employee activities and department details are stored in Employees
table and Departments table. Write the appropriate query to support the manager to complete the
following

1. Use Employees table a) To display First_Name, Salary and Department_id ofall the employees, whose Department_id is either 50 or 80 and the salary is more than 5000 or the total letters of the first_name should be more than or equal to 6 and the First_Name should contain letter "e" at the second position from the last. b) When do we use the SQL Wildcard Characters and "%" with an example each?
Transcribed Image Text:1. Use Employees table a) To display First_Name, Salary and Department_id ofall the employees, whose Department_id is either 50 or 80 and the salary is more than 5000 or the total letters of the first_name should be more than or equal to 6 and the First_Name should contain letter "e" at the second position from the last. b) When do we use the SQL Wildcard Characters and "%" with an example each?
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS