SQL: Advanced Queries

[@pritamkrishna1977]

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

[@supratiksarkar1195]

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

[@robertspilko315]

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)

[@BalamurugaMuthumani]

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

[@neerunagi225]

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?

[@utsavsingh4179]

You're right.