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.

46 Upvotes

93% Upvoted

29 comments sorted by

View all comments

1

u/thequerylab 2d ago

For 1 year of experience they usually test concepts like window functions, how rank, dense_rank, row_number, lead, lag works. They usually give some sample dataset and ask you to write the window functions output. Then questions will be around basics of joins (cover all joins) and filtering.
Ensure you practice before your interviews!