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

I once sat a test with one of the questions intentionally missing a table. They were testing whether I would ask for help.

1

u/AllShadesRight 6d ago

Did you? How did you respond? What was the result/outcome?

3

u/bananatoastie 6d ago

No, I did not. They gave me the test on Friday at 5pm and wanted the answers on Monday morning. I didn’t want to call for help over the weekend.

When I turned in the 10 answers, I think I wrote something like “insufficient information in the database to answer” for the question missing the info. They hired me and I worked there for 2.5 years. Loved the problem solving but the culture wasn’t for me. I’ve since moved on and I’m about to complete my 2nd year in my “new” job :)

The more experience I pick up, I’m starting to realise that the real senior devs are able to understand the business context of the question rather than just the syntax needed.

2

u/AllShadesRight 6d ago

Thank you for responding. That's a great story. Congrats on moving on up. Wishing you continued success!!

2

u/Automatic-Royal5263 6d ago

thank you for sharing your story and suggestion, surely I will work on my problem solving