SQL Optimization resources

Hi everyone, A lot of interviewers ask questions about SQL optimization in interviews. Can anyone suggest good sources to study this topic? TIA