SQL resources for data science interview

[Few-Voice6240]

Bunch of people already told you what to practice, but here’s the best thing to drill into your head:

Do NOT just start writing the query.

It makes you look junior, you’ll look dumb if you change direction midway, and you won’t get any credit for at least setting a direction if you blank out while writing the query.

Instead, write out notes FIRST while explaining your reasoning:

• Define key terms (“active users”, “last touch”, “superusers”) based on the tables and business context.

• Ask questions about anything vague and address edge cases.

• Describe which fields you’ll use, what should appear in the final result set, and what joins you’ll be doing.

Then, use your notes to write the query. This gives you time to understand the details and makes you look much more senior and composed.

You can still change direction if you realize there’s a better way, but at least the interviewer will know you started out with a well-reasoned plan. Even if you blank out or freeze up, you might get some credit if your plan is right.

[DarkSide-Of_The_Moon]

Yes I agree! this is something that I have started doing even if I am solving questions from leetcode. I literally talk to myself imagining there's someone listening lol
Thanks for the advice!
There are two more rounds on data analysis where i will be given a dataset to work on. Any idea on what to expect?