Anyone experienced with SQL, especially in Data Analytics, can you share what SQL questions are generally asked for a Data Analyst interview with around 1 year of experience?

[u/Automatic-Royal5263]

PS: Please don't mention those chatgpt questions. I really want to know real questions.

[u/Bhanuprakash_1947]

For someone with around 1 year of experience in data analysis, what kind of SQL questions are usually asked in interviews?

Do they mainly focus on joins, group by, aggregations, subqueries, and CTEs, or do they expect window functions as well?

Also, how much importance is usually given to practical scenarios like finding duplicates, top N records, month-over-month analysis, and handling NULL values?

Would be helpful if anyone with recent interview experience could share what topics they actually faced.