Interviewed on Feb-23 2021 United States

1. How do you rate your SQL skill in the range of 1 to 10?
2. LP question
3. What is Fact and Dimensions tables?
4. He showed me Orders, Products and Sellers tables and asked what metrices would you consider if you want to build a visualization? And what type of visuals you would use?
5. 5 SQL questions using the above tables mostly using windows functions LAG, LEAD, CTE
6. Initial SQL questions were easy and final one was how Product1 and Product2 performed for the first 100 days from their launch date. The result should be like Day1 Product1 Product2