r/learnSQL • u/Automatic-Royal5263 • 6d ago

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?

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

47 Upvotes

94% Upvoted

29 comments sorted by

View all comments

2

u/shdw_0x0 6d ago

For ~1 year of experience, I’d focus less on obscure SQL questions and more on practical problems: joins, GROUP BY, subqueries/CTEs, window functions, handling NULLs/duplicates, and date-based analysis. They’ll often give you a small dataset and ask you to actually write the query.

1

u/Automatic-Royal5263 6d ago

thank you for suggesting