Solving a tricky SQL Interview Query
In this video, let's solve an SQL query which can be pretty commonly asked during SQL interviews.
This is a basic to intermediate level of SQL interview problem which can be commonly asked during interviews. If not the same problem but problems similar to this can be asked.
By practicing to solve these kind of sql queries, you will get to know how to use window functions, frame clause, cte and more importantly how to apply simple logics when solving sql problems.
Download the dataset and scripts from below:
