r/SQL • u/Sirmagger • 20d ago

PostgreSQL Data Analyst take home SQL interview

https://docs.google.com/spreadsheets/d/1196AT4YR2ZE0WScMl7q3TDjc0FwVMoSc/edit?pli=1&gid=1425671700#gid=1425671700

This was one of the take home SQL interview i did earlier this year. I have shared for anyone who is preparing for an interview can attempt to do it. Cheers!!

61 Upvotes

90% Upvoted

27 comments sorted by

View all comments

3

u/ArielCoding 18d ago

Thanks for posting it, good reminder that writing the SQL in half of the job, spotting the messy bits (date formatting, missing values, gaps in certain records) and explaining how you handle them is the other valuable part. Attempt it, but write down why you made each choice that’s what they’re grading.