WinZO Interview Questions, Process, and Tips

• Q1. All about your self.......................................
  Add Answer

• Q1. Metric to determine the new users in a platform
  View Answers (1)

• Q1. Low level design of workflow engine
  View Answers (1)

• Q1. Design a notification system which supports immediate, delayed and repeated notifications
  View Answers (1)

• Q1. Resume walk through and questions from past work ex. Overview of the app, what can be improved.
  Add Answer

Intermediate SQL Topics - Window Function, Subquery, Joins

Tables:
registration (userid string, regdate date);
txn(txndate date, userid string, amt int, game string);

1. Write a query to get proportion of users who have played a game within 2 days of registration
2. Find the most money spent on a game for each user
3. Get the list of users who played poker but not ludo