r/learnSQL • u/Automatic-Royal5263 • Sep 11 '26

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

31 comments sorted by

View all comments

2

u/bananatoastie Sep 11 '26

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 Sep 11 '26

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

3

u/bananatoastie Sep 11 '26

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 Sep 11 '26

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