Find the first names and last names of employees if they got a salary increase more than 10% in the first month of 2000 together with their salary change dates, old salaries, new salaries, and increase percentages in descending order by their increase percentages. Suppose that you are given a database that records information about humanresources of a large multi-national company. You can find the enhanced en-tity relationship diagram of this database below. Answer the following questionby writing an SQL query on this database. You are given an example outputfor the question. Records with '9999-01-01’ as their to date attribute are thecurrent ones.O salariesDemployeesO titlesemp_no INT(11)emp_no INT(11)emp_no INT(11)Osalary INT(11)from_date DATEO birth_date DATEtitle VARCHAR(50)O first_name VARCHAR(14)from_date DATEto date DATElast_name VARCHAR(16)O gender ENUM(M, F)O to_date DATEIndexesIndexenPRIMARYhire date DATEPRIMARYPRIMARYdept empemp_no INT(11)O dept_managerK dept_no CHAR(4)emp_no INT(11)Edepartmentsfrom_date DATEdept_no CHAR(4)dept no CHAR(4)to date DATEfrom_date DATEOdept _name VARCHAR(40)IndexesPRIMARYOto_date DATEIndexesPRIMARYdept_noPRIMARYdept namedept_noFind the first names and last names of employees if they got a salary increasemore than 10% in the first month of 2000 together with their salary changedates, old salaries, new salaries, and increase percentages in descending orderby their increase percentages.mew salary mercentage first_namelast_namechange date2000-01-11old salary new salary percentage40000JacquelineKaijungGroIsaac4449311.2325A Hatcliff2000-01-20401134461311.2183Hebert2000-01-12400004444911.1225KristenMatteis2000-01-1643955414054836010.0216SifakisCaineAlenka2000-01-194555010.0109Hairong2000-01-16417984598210.0100

create table commands and inserting sample data into the table for query create table employees…

Answered: Find the first names and last names of…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Find the first names and last names of employees if they got a salary increase more than 10% in the first month of 2000 together with their salary change dates, old salaries, new salaries, and increase percentages in descending order by their increase percentages.