The interview was scheduled for 3 rounds. Interview was held on Google Hangouts 1st Round : SQL Technical Questions: * What is the order of query execution *Difference between from and where clause *Window functions *Providing example tables and SQL query question based on that [ difficulty level : Hard ] Example: Sample Table: Customer Id | Date Of Purchase | Product | Price A | 10 - 01 - 2000 | Phone | 10000 B | 27 - 07 - 2005 | Laptop | 50000 A | 17 - 10 - 2012 | TV | 75000 The result table should contain distinct customer, Each distinct customer one year data from their first purchase, top 5 frequent product purchased by them *What type of insights you can extract from the given sample table 2nd - Round Scenario Based Questions *Given a particular brand , its sales this week is 10L, How would increase the sales to 20L within the one day ? *Estimate per days sales of "Myntra"? *How Myntra is making money, What are the factors involved? *How would you increase sales on women products? 3rd - Round Did not happen.