How to highlight the last 3 contracts in a SQL query?

Question

SQL

There is a Contracts schema :

• skp_contract INT
  
• approval_date DATETIME
  
• code_employee INT
  
• amt_credit INT
  

You need to display the last 3 contracts of each employee. I have no idea how to get the last 3 contracts for each employee. It turned out to display the sum of all contracts for each, but not the last. Everything he wrote:

SELECT code_employee, SUM(amt_credit) 
FROM Contracts 
GROUP BY code_employee;

Can you suggest where to dig ?

Answer 1

Look here:
https://dba.stackexchange.com/questions/116142/get...

Answer 2

SELECT code_employee, SUM(amt_credit) 
FROM Contracts 
GROUP BY code_employeem, approval_date 
ORDER BY approval_date DESC
LIMIT 3

Sort in descending order by acceptance date.