The analytics_and_recursion_explainers subproject has the scripts and artefacts for a Twitter thread in which I explain how three SQL techniques work, in a single tweet recording (< 2m20s) each.
Example of recursion in sqllite creating a file hierachy r and python sql multi language %let pgm=utl-example-of-recursion-in-sqllite-creating-a-file-hierachy-r-and-python-sql-multi-language; ...