Toughest SQL questions

Uber
vucR46

Go to company page Uber

vucR46
Feb 18, 2017 20 Comments

Can you please share the links for the most advanced SQL interview questions?

Thanks

comments

Want to comment? LOG IN or SIGN UP
TOP 20 Comments
  • Uber
    nooner

    Go to company page Uber

    nooner
    Know how to use window functions
    Feb 18, 2017 10
  • Airbnb
    toodles

    Go to company page Airbnb

    toodles
    combination recursive SQL (I want to know how many total new users we can attribute to each user if you go infinitely deep in the referral tree. do some additional math to attribute only a portion of the referral credit based on how deep in the tree it is.) and window functions with rolling aggregations (monthly active users for the last year at the daily level). about as complicated it gets (which really isn't that rough). then it comes down to optimization techniques which is usually pretty DB specific so the questions rarely get too rough there.
    Feb 19, 2017 0
  • eBay
    JHgY68

    Go to company page eBay

    JHgY68
    Might be easy for someone, but bumped me out during one of my interviews.

    How do you compute rolling 7 days moving average in SQL (efficiently)?
    Feb 18, 2017 0
  • Tableau
    Y5h2q9

    Go to company page Tableau

    Y5h2q9
    if you have a database with a decent optimizer it shouldn't matter too much what you write in SQL.
    Feb 20, 2017 1
  • Lyft
    aBbK04

    Go to company page Lyft

    aBbK04
    do people actually ask data scientists (not analysts) SQL questions?
    Feb 19, 2017 1