First Transaction — SQL Question Asked By Etsy
Solving SQL Question Asked By Etsy
3 min readOct 11, 2022
Originally Published in https://asyncq.com/
Introduction
- In this article we will solve First Transaction SQL question which is asked by Microsoft as per DataLemur website.
If you don’t know DatLemur then please do visit , it’s one of the best website to practice SQL questions and improve your SQL skills.
Question
- We have been given user_transaction table , and we need to query users who made their first transaction of worth $50 or more.
- As we can see there is only one user with id 156 made their first transaction of $87.
Solution
- At first , we need to partition entire table based on user_id and sort them based on transaction data in ascending order.
- We can do this using window function as shown below. we are ranking each record…
