starting with 'S' and ending with 'H'. 7. Write a query to display the employees who joined in June. 3. Write a query to display the employees who does not work in department

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 93C
icon
Related questions
icon
Concept explainers
Question
Use SQL Developer.
6. Write a query to display the employees who have Five character names
starting with 'S' and ending with 'H'.
7. Write a query to display the employees who joined in June.
8. Write a query to display the employees who does not work in department
number 30.
9. Write a query to display all employees except 'PRESIDENT' &
'MANAGER" in ascending order by Salaries.
10. Write a query to display the employees of Deptno 20 or 10 joined in the year
1981.
Transcribed Image Text:6. Write a query to display the employees who have Five character names starting with 'S' and ending with 'H'. 7. Write a query to display the employees who joined in June. 8. Write a query to display the employees who does not work in department number 30. 9. Write a query to display all employees except 'PRESIDENT' & 'MANAGER" in ascending order by Salaries. 10. Write a query to display the employees of Deptno 20 or 10 joined in the year 1981.
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Query Syntax
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