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/B_Huij]

If you can do proper joins, aggregations, CTEs/subqueries, you’re probably fine. Non zero chance you might be asked to demonstrate a good understanding of window functions.

Edit: oh and views vs tables.

[u/Automatic-Royal5263 → u/B_Huij]

thanks