Sql assessment

Snap
wombi

Go to company page Snap

wombi
Apr 24 7 Comments

I new to sql live assessments in general. Is it ok if I run the code for sub queries and parts of the query to see the output or is it expected of me to get everything right before submission?

Any other tips and recommendations for a newbie?
I’m currently using strata scratch to practice but the Interface might be too nice to be true as it shows me the expected output. I’m worried that I won’t see that during the interview. - should I try to avoid checking the expected output?

Thanks 🙏

#dataanalytics #data #datascience

comments

Want to comment? LOG IN or SIGN UP
TOP 7 Comments
  • Walmart
    qwerty2121

    Go to company page Walmart

    qwerty2121
    When i started preparing on LC for SQL i used to do the same but during interviews i struggled to imagine the output as i was so used to look at the table as well as the expected solution. Now i just look at the table contents and try to solve it
    Apr 24 0
  • I feel like this is a reasonable and good way do actually do the job of writing code so why not do it in an interview?

    I think it’s more how you frame it. If it’s like “Lemme run this to see if it’s right because it really could go either way” that’s a red flag. If it’s more “So first, before I join to activity data, I want to get a table with one row per user. Here I am writing that code. Now, before we move on, let’s take a peak at that. If I were writing this for real, I’d probably stop here and do checks for bulls or duplicates before joining. For the sake of this case, we will just eyeball it”
    Apr 24 4
    • Also not sure if you use CTEs but I think this can make it even easier to do this since you are writing the query linearly instead of “inside out”
      Apr 24
    • Snap
      wombi

      Go to company page Snap

      wombi
      OP
      I’m doing the simplest things with CTEs lol my fear is that they ask if if I can do it w/o CTE since joins can often be faster
      Apr 24
  • Lynden Incorporated
    DFJz86

    Lynden Incorporated

    DFJz86
    I've never been able to execute SQL during an interview
    Apr 24 0