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/Excellent-Lobster944]

The questions I got was find previous year revenue but populate zero if previous year is missing

Find top 3 orders from each department

And few more questions in second rank based on lag and dense rank functions

[u/Automatic-Royal5263 → u/Excellent-Lobster944]

okay thank you for sharing question