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.