Write a query using mysql to display grant title, summary and grand amount which was received during the past decade. Sort the data by title & amount

Write a query that returns the EMP_NUM and Number of ratings he/she earned (based on EARNEDRATING table, call this Num_RTG), for those who had at least got 1 rating earned, but the number of ratings he/she earned must lower than the average number of ratings for all employees who had earned ratings before, and such employee has been served as “Copilot” before.

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). EMP NUM EMP INAME EMP FNAME SAL FROM SAL END SAL AMOUNT 83731 VARGAS SHERON 20140-15 2015a-14 43.00 VARSAS SHERON 2015014 2016--13 481.00 83731 VARGAS SHERON 2016 04 201714 4.00 VARGAS SHERON 20170715 NUL S1040.00 SPICER DWAN 201102 2012-0-01 83745 SPICER 2012 0-2 2013-0-02 S7700.00 DWAN 3745 SCER DWAN 2013 o 2014-08-01 63470.00 SPICER DWAN 2014 08-02 2015-08-01 se.00 SPICER DWAN 2015O1 2010--31 71.00 SPICER DWAN 2016 O01 2017-08-01 7414.00 Figure P7.31 In the SQL Query do the following Select clause: Display the columns specified above in the problem statement from LGEMPLOYEE and LGSALARY_HISTORY tables From: Since we are displaying the information from these two tables specify the join condition here or in the where clause Where clause: Only…

Write a query to display the customer code, first name, and last name of all customers who have had at least one invoice completed by employee 83649 and at least one invoice completed by employee 83677. Sort the output by customer last name and then the first name.