Query design by referring the following scenario. company has a huge database to handle their employees details.Most of the details regarding the employee activities and department details are stored in Employeestable and Departments table. Write the appropriate query to support the manager to complete thefollowing 2. Use Employees table and design the following query with the help of CASE expression to:To display the First_Name in capital letters, the first three letters of Last_Name and a newcolumn "Remarks" with the department_id, based on the following conditions:o If Department_id is 50, display Shippingo If Department_id is 60, display ITOtherwise, display OthersThe output should display only the employees who have salaries.Make sure that you are arranging the output in alphabetical order of First_Name.

Query: SELECT upper(First_Name) as First_Name,…

Answered: 2. Use Employees table and design the…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

Query design by referring the following scenario. 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

2. Use Employees table and design the following query with the help of CASE expression to:
To display the First_Name in capital letters, the first three letters of Last_Name and a new
column "Remarks" with the department_id, based on the following conditions:
o If Department_id is 50, display Shipping
o If Department_id is 60, display IT
Otherwise, display Others
The output should display only the employees who have salaries.
Make sure that you are arranging the output in alphabetical order of First_Name.

Expert Solution

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

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.

Similar questions