Sobes.tech
Junior — Middle+

Creating an index for the specified SELECT query

livecode

Task condition

Formulate an appropriate index that optimizes the execution of the following SQL query:

SELECT * 
FROM employee 
WHERE sex = 'm' 
  AND salary > 300000 
  AND age = 20 
ORDER BY created_at;

Describe which columns should be included in the index and in what order to minimize the number of reads and speed up the sorting of the result.