postgresql_code

Name		Name	Last commit message	Last commit date
parent directory ..
01-create-table.sql		01-create-table.sql
02-create-nodes.sql		02-create-nodes.sql
03-finding-root-node.sql		03-finding-root-node.sql
04-finding-the-immediate-children-of-a-node.sql		04-finding-the-immediate-children-of-a-node.sql
05-find-how-many-immediate-children-a-node-has.sql		05-find-how-many-immediate-children-a-node-has.sql
06-finding-the-leaf-nodes-sub-query.sql		06-finding-the-leaf-nodes-sub-query.sql
07-finding-the-leaf-nodes-left-join.sql		07-finding-the-leaf-nodes-left-join.sql
08-find-full-path.sql		08-find-full-path.sql
09-find-full-path-as-list-with-depth.sql		09-find-full-path-as-list-with-depth.sql
10-query-a-sub-tree-top-bttom.sql		10-query-a-sub-tree-top-bttom.sql
11-query-a-sub-tree-bottom-up.sql		11-query-a-sub-tree-bottom-up.sql
12-get-the-row-number-for-each-group.sql		12-get-the-row-number-for-each-group.sql
README.md		README.md

README.md

The tree from the videos:

stateDiagram-v2
    Fruits --> Apple
    Fruits --> Mango
    Apple --> Green Apple
    Apple --> Yellow Apple
    Apple --> Red Apple

Here you can find the SQL code for the nested sets model written in PostgreSQL 13.3-1.pgdg100+1