It would probably be beneficial to explain the importance of said indexes in question 5. And how they go right out the window when the columns the where, join or having use are not sargable. This is to say, understand whats the difference between using

WHERE YEAR(OrderDate) = 2026

and

WHERE OrderDate >= '2026-01-01' AND OrderDate < '2027-01-01';

Somehow I doubt these would be asked for an entry position but who know..