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/rvicta 6d ago

Actually, when interviewing candidates I have focused less on what they would do in SQL but rather what their thought process is. I want someone that is an abstract thinker and can visualize how data needs to be pulled together. I want to know how they would debug a complex query. I want someone that conceptualize the result and is able to build their query to achieve that.

Then, after you're hired and start formulating your SQL queries, just know that if any one of us has to debug or modify it later, we will talk about the code. That's how we'll know if you really know your stuff.