Understand over() clause in comparison with group by and equivalent code [using inner join and subquery].

**Over()** It is a similar thing to group by but instead of shrinking the table it initializes the value in front of each column & gives its results in front of every row. Group by only gives aggregated columns, other columns are not shown while we...