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

Opendoor SQL Interview Question

Opendoor SQL Interview Question

Question: Assume you are given the below table on house prices of listed properties from various zip codes. Write a query to get the top 5 zip codes by market share of house prices for all zip codes. Also return the corresponding market share (in %, 2 decimal) as well and filter zip codes with … Read more