Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Task 2: Conversion Function 1. Display last name, first name and hire date of all employees hired before 2008. Display the hire date in this

image text in transcribed

Task 2: Conversion Function 1. Display last name, first name and hire date of all employees hired before 2008. Display the hire date in this format (example: "January 25, 2018") 2. Displays the last names of employees under the manager id 124 or 122 . Also generate an email add from getting the first 4 letters of first name of each employee. Example: rico@adpoly.ac.ae. Task 3: Group Function and Group Rows 1. Display how many employees with a salary that is less than 6000 in each job id, in each department. 2. Display the average, maximum, and minimum salary of all employees under a manager with ID 110 or 150 3. Display the last name, first name, department, and city of all employees working with the manager of the department with id number 103 or 205. 4. Count how many employees working in each country per department. Display only with number of employees of more than 20

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design Application Development And Administration

Authors: Michael V. Mannino

3rd Edition

0071107010, 978-0071107013

More Books

Students also viewed these Databases questions

Question

=+ Are unions company-wide, regional, or national?

Answered: 1 week ago

Question

=+j Explain the litigation risks in international labor relations.

Answered: 1 week ago

Question

=+j What rules will apply to the process of negotiations?

Answered: 1 week ago