Zoom Communications Interview Question
SQL: 1. Dynamic join - Left Join to get next day's data. Join on a.order_date = b.order_date + 1. 2. Use CTE to join multiple tables. Use window function (Dense Rank Over).
SQL: 1. Dynamic join - Left Join to get next day's data. Join on a.order_date = b.order_date + 1. 2. Use CTE to join multiple tables. Use window function (Dense Rank Over).
Check out your Company Bowl for anonymous work chats.