Write a query to display the employee number, last name, first name, salary "from" date,salary end date, and salary amount for employees 83731, 83745, and 84039. Sort theoutput by employee number and salary "from" date (Figure P7.31).EMP NUMEMP INAMEEMP FNAMESAL FROMSAL ENDSAL AMOUNT83731VARGASSHERON20140-152015a-1443.00VARSASSHERON20150142016--13481.0083731VARGASSHERON2016 042017144.00VARGASSHERON20170715NULS1040.00SPICERDWAN2011022012-0-0183745SPICER2012 0-22013-0-02S7700.00DWAN3745SCERDWAN2013 o2014-08-0163470.00SPICERDWAN2014 08-022015-08-01se.00SPICERDWAN2015O12010--3171.00SPICERDWAN2016 O012017-08-017414.00Figure P7.31In the SQL Query do the followingSelect clause: Display the columns specified above in the problem statement fromLGEMPLOYEE and LGSALARY_HISTORY tablesFrom: Since we are displaying the information from these two tables specify the joincondition here or in the where clauseWhere clause: Only displaying information for employees that emp_num equal to83731, 83745, and 84039. You can use IN operator hereOrder by clause: Please sort as per the sorting criteria listed in the problem statement.

Two tables must be joined using INNER JOIN clause. Give the conditions in WHERE clause. Sort the…

Write a query to display the employee number, last name, first name, salary "from" date, salary end date, and salary amount for employees 83731, 83745, and 84039. Sort the output by employee number and salary "from" date (Figure P7.31).

Write a query to display the employee number, last name, first name, salary "from" date, salary end date, and salary amount for employees 83731, 83745, and 84039. Sort the output by employee number and salary "from" date (Figure P7.31).

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

Similar questions

Write a query to display the employee number, last name, first name, salary “from” date, salary end date, and salary amount for employees 99675, 53845, and 44035. Sort the output by employee number and salary “from” date.
Write a query to list the book title, checkout date, checkout due date and checkout in date for each book.
Write a query to display the employee number, last name, first name, salary “from” date, salary end date, and salary amount for employees 83731, 83745, and 84039. Sort the output by employee number and salary “from” date (Refer to Figure P7.31)
Write a query to get the maximum and minimum salary from the senators table (in that order).
Write a query to display the first name, last name, phone number, title, and department number of employees who work in department 300 or have the title “CLERK I.” Sort the output by last name and then by first name
Write a query to display the customer code, balance, and total purchases for each customer. Total purchase is calculated by summing the line subtotals (as calculated in Problem 12) for each customer. Sort the results by customer code, and use aliases as shown in Figure P7.13
Create a query to show the Technician Number, Last Name, First Name, Client Number,and Client Name for clients whose technician number is 23 (use Boolean variables).Save your query
Write a query to display the movie title, movie year, price description, and price rental fee for all movies in all categories except for family where the table name is Movies.