Stitch Fix SQL Interview Question

Stitch Fix SQL Interview Question

Question:  You have been given the below table on transactions from users. Write a query to get the number of users and total products bought per latest transaction date where each user is bucketed into their latest(last) transaction date. Explanations & Definition: every user will have a last(lastest) transaction date, also multiple users can have the … Read more

Disney SQL Interview Question

disney sql interview

Question: Assume you are given the below table on watch times (in minutes) for all users, where each user is based in a given city. Write a query to return all pairs of cities with total watch times within 10000 minutes of one another. Difficulty Level: Easy, Source: Nicksingh, Tag: Disney SQL Interview Question Assumptions: No NULLS present; DBMS: … Read more