Question

Cenage MySQL question 31

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). FIGURE P7.31 SALARY HISTORY FOR SELECTED EMPLOYEES EMP NUM EMP LNAME EMP FNAME SAL FROM SAL END SAL AMOUNT 83731 VARGAS SHERON 7/15/2014 7/14/2015 43740 83731 VARGAS SHERON 7/14/2015 7/13/2016 48110 83731 VARGAS SHERON 7/14/2016 7/14/2017 49560 83731 VARGAS SHERON 7/15/2017 51040 83745 SPICER DWAIN 8/2/2011 8/1/2012 56020 83745 SPICER DWAIN 8/2/2012 8/2/2013 57700 83745 SPICER DWAIN 8/3/2013 8/1/2014 63470 83745 SPICER DWAIN 8/2/2014 8/1/2015 68550 83745 SPICER DWAIN 8/1/2015 7/31/2016 71980 83745 SPICER DWAIN 8/1/2016 8/1/2017 74140 83745 SPICER DWAIN 8/2/2017 76360 84039 COLEMAN HANNAH 6/28/2014 6/27/2015 47380 84039 COLEMAN HANNAH 6/27/2015 6/26/2016 51170 84039 COLEMAN HANNAH 6/27/2016 6/27/2017 52700 84039 COLEMAN HANNAH 6/28/2017 54280 41% Page 32 of 806 . Location 8142 of 19905 MacBook Air

Answer 1

Since you have not provided the db schema, I am providing the query by guessig the table and column names. Feel free to reach out for any clarifications. Please find the SQL query below,

QUERY

SELECT EMP_NUM, EMP_LNAME, EMP_FNAME, SAL_FROM, SAL_END, SAL_AMOUNT FROM EMPLOYEE WHERE EMP_NUM IN (83731, 83745, 84039) ORDER BY EMP_NUM, SAL_FROM;