SQL: Advanced Queries 

Execution Order: 1> From 2> Where 3> Group By 4> having 5> Select 6> Order By

Sir, you could have shown using VS Code, or SQL Workbench. This writing by hand is so cumbersome.

In "Duplication in set" You should declare that "t" and "s" are not the same element.(which is the statement itself, so it is a little bit confusing :D)

in the last example the avg bal was compared instead of assets as per the ques...y?????

Nice lecture sir, just one doubt at 2:47, why do we need to join with Customer table. we already got the cname from depositor or borrower relations?