Boost interview questions

Hr interview and then home assignment. Didnt pass the home assignment. The hr interview was long and included details from high school until now. They asked about hobbies, projects, volunteer activities and more

"The interviewer asked about SQL functions, including the different types of SQL joins and their explanations, the concept of DENSE_RANK, techniques for query optimization, and the difference between WHERE and HAVING clauses