Nice article! However, it would have made it complete if terminating condition and LOOPing would have also been included.

DISTINCT is a strict prohibition in our team. Any usage of DISTINCT needs to be specifically approved, if at all it is to be used, and it ought to be...