Please help from attached file.Find the distinct number of workers who work in the HR department and who earn more than ₹250,000.Find the last name and title of all workers and the department they work in who earn less than the average salary.What is the average salary paid for all workers in each department? List the department, the average salary for the department, and the number of workers in each department. Name the average column 'AvgSal' and the number of workers column to 'Num'.What is the total compensation for each worker (salary and bonus) on a per monthly basis? List the name of the worker, their title, and the their monthly compensation (annual compensation divided by 12). Change the header for compensation to 'MonthlyComp' and round it to the nearest whole number.List the full names of all workers in all capital letters who did not get a bonus.What are the full names of all workers who have 'Manager' in their title. Do not "hard code" the titles; use string searching. DROP TABLE IF EXISTS Worker;CREATE TABLE Worker ();0INSERT);WORKER_ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,FIRST NAME TEXT,LAST NAME TEXT,SALARY INTEGER (15),JOINING DATE DATETIME,DEPARTMENT CHAR (25)INTO Worker(WORKER_ID, FIRST_NAME, LAST_NAME, SALARY, JOINING_DATE, DEPARTMENT) VALUES'Arora', 100000, '14-02-20 09.00.00', 'HR'),(001, 'Monika',(002, 'Niharika','Verma' 80000, '14-06-11 09.00.00', 'Admin'),'HR'),'Admin'),Admin'),'Account'),'Kumar', 75000, '14-01-20 09.00.00', 'Account')DROP TABLE IF EXISTS Bonus;CREATE TABLE Bonus ();(003, 'Vishal' 'Singhal', 300000, '14-02-20 09.00.00',(004, 'Amitabh'Singh', 500000, '14-02-20 09.00.00',(005, 'Vivek' 'Bhati', 500000, '14-06-11 09.00.00'.(006, 'Vipul', 'Diwan' 200000, '14-06-11 09.00.00',(007, 'Satish'(008, 'Geetika', 'Chauhan', 90000, '14-04-11 09.00.00', 'Admin');WORKER_REF_ID INTEGER,BONUS AMOUNT INTEGER(10),BONUS_DATE DATETIME,FOREIGN KEY (WORKER_REF_ID)REFERENCES Worker (WORKER_ID)ON DELETE CASCADEINSERT INTO Bonus(WORKER_REF_ID, BONUS_AMOUNT, BONUS_DATE) VALUES(001, 5000, '16-02-20'),(002, 3000,'16-06-11'),(003, 4000, '16-02-20'),(001, 4500, '16-02-20'),(002, 3500, '16-06-11');CREATE TABLE Title (WORKER_REF_ID INTEGER,WORKER_TITLE VARCHAR(64),AFFECTED FROM DATETIME,FOREIGN KEY (WORKER_REF_ID)REFERENCES Worker (WORKER_ID)ON DELETE CASCADEINSERT INTO Title(WORKER_REF_ID, WORKER_TITLE, AFFECTED_FROM) VALUES(001, 'Manager', '2016-02-20 00:00:00'),(002, 'Executive', '2016-06-11 00:00:00'),(008, 'Executive' '2016-06-11 00:00:00'),(005, 'Manager', '2016-06-11 00:00:00'),(004,'Asst. Manager', '2016-06-11 00:00:00'),(007, 'Executive', '2016-06-11 00:00:00'),(006,'Lead', '2016-06-11 00:00:00'),(003, 'Lead', '2016-06-11 00:00:00');I

1.select distinct FIRST_NAME, LAST_NAME, SALARY, DEPARTMENT from Worker Where DEPARTMENT ='HR' And…

Answered: Please help from attached file. Find…

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

Question

Please help from attached file.

Find the distinct number of workers who work in the HR department and who earn more than ₹250,000.
Find the last name and title of all workers and the department they work in who earn less than the average salary.
What is the average salary paid for all workers in each department? List the department, the average salary for the department, and the number of workers in each department. Name the average column 'AvgSal' and the number of workers column to 'Num'.
What is the total compensation for each worker (salary and bonus) on a per monthly basis? List the name of the worker, their title, and the their monthly compensation (annual compensation divided by 12). Change the header for compensation to 'MonthlyComp' and round it to the nearest whole number.
List the full names of all workers in all capital letters who did not get a bonus.
What are the full names of all workers who have 'Manager' in their title. Do not "hard code" the titles; use string searching.

DROP TABLE IF EXISTS Worker;
CREATE TABLE Worker (
);
0
INSERT
);
WORKER_ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
FIRST NAME TEXT,
LAST NAME TEXT,
SALARY INTEGER (15),
JOINING DATE DATETIME,
DEPARTMENT CHAR (25)
INTO Worker
(WORKER_ID, FIRST_NAME, LAST_NAME, SALARY, JOINING_DATE, DEPARTMENT) VALUES
'Arora', 100000, '14-02-20 09.00.00', 'HR'),
(001, 'Monika',
(002, 'Niharika',
'Verma' 80000, '14-06-11 09.00.00', 'Admin'),
'HR'),
'Admin'),
Admin'),
'Account'),
'Kumar', 75000, '14-01-20 09.00.00', 'Account')
DROP TABLE IF EXISTS Bonus;
CREATE TABLE Bonus (
);
(003, 'Vishal' 'Singhal', 300000, '14-02-20 09.00.00',
(004, 'Amitabh
'Singh', 500000, '14-02-20 09.00.00',
(005, 'Vivek' 'Bhati', 500000, '14-06-11 09.00.00'.
(006, 'Vipul', 'Diwan' 200000, '14-06-11 09.00.00',
(007, 'Satish'
(008, 'Geetika', 'Chauhan', 90000, '14-04-11 09.00.00', 'Admin');
WORKER_REF_ID INTEGER,
BONUS AMOUNT INTEGER(10),
BONUS_DATE DATETIME,
FOREIGN KEY (WORKER_REF_ID)
REFERENCES Worker (WORKER_ID)
ON DELETE CASCADE
INSERT INTO Bonus
(WORKER_REF_ID, BONUS_AMOUNT, BONUS_DATE) VALUES
(001, 5000, '16-02-20'),
(002, 3000,
'16-06-11'),
(003, 4000, '16-02-20'),
(001, 4500, '16-02-20'),
(002, 3500, '16-06-11');
CREATE TABLE Title (
WORKER_REF_ID INTEGER,
WORKER_TITLE VARCHAR(64),
AFFECTED FROM DATETIME,
FOREIGN KEY (WORKER_REF_ID)
REFERENCES Worker (WORKER_ID)
ON DELETE CASCADE
INSERT INTO Title
(WORKER_REF_ID, WORKER_TITLE, AFFECTED_FROM) VALUES
(001, 'Manager', '2016-02-20 00:00:00'),
(002, 'Executive', '2016-06-11 00:00:00'),
(008, 'Executive' '2016-06-11 00:00:00'),
(005, 'Manager', '2016-06-11 00:00:00'),
(004,
'Asst. Manager', '2016-06-11 00:00:00'),
(007, 'Executive', '2016-06-11 00:00:00'),
(006,
'Lead', '2016-06-11 00:00:00'),
(003, 'Lead', '2016-06-11 00:00:00');
I

Expert Solution

Trending now

This is a popular 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