Can You Solve This Hard SQL Question😢😢 | Parent Child Hierarchy | Recursive CTE скачать в хорошем качестве

Can You Solve This Hard SQL Question😢😢 | Parent Child Hierarchy | Recursive CTE

In this video we will discuss a very interesting SQL question which involves parent child hierarchy and we need to use recursive CTE to flatten it. Want to solve more challenging questions : https://www.namastesql.com/coding-pro... scripts: CREATE TABLE Politician ( pname VARCHAR(10) PRIMARY KEY, party CHAR(1) ); CREATE TABLE Company ( cname VARCHAR(10) PRIMARY KEY, revenue INT ); CREATE TABLE Invested ( pname VARCHAR(10), cname VARCHAR(10) ); CREATE TABLE Subsidiary ( parent VARCHAR(10), child VARCHAR(10) ); -- Politicians INSERT INTO Politician (pname, party) VALUES ('Don', 'R'), ('Ron', 'R'), ('Hil', 'D'), ('Bill', 'D'); -- Companies INSERT INTO Company (cname, revenue) VALUES ('C1', 110), ('C2', 30), ('C3', 50), ('C4', 250), ('C5', 75), ('C6', 15); -- Investments INSERT INTO Invested (pname, cname) VALUES ('Don', 'C1'), ('Don', 'C4'), ('Ron', 'C1'), ('Hil', 'C3'); -- Subsidiary relationships INSERT INTO Subsidiary (parent, child) VALUES ('C1', 'C2'), ('C2', 'C3'), ('C2', 'C5'), ('C4', 'C6'); Zero to hero(Advance) SQL Aggregation:    • All About SQL Aggregations | SQL Advance |...   Most Asked Join Based Interview Question:    • Most Asked SQL JOIN based Interview Questi...   Solving 4 Trick SQL problems:    • Solving 4 Tricky SQL Problems   Data Analyst Spotify Case Study:    • Data Analyst Spotify Case Study | SQL Inte...   Top 10 SQL interview Questions:    • Top 10 SQL interview Questions and Answers...   Interview Question based on FULL OUTER JOIN:    • SQL Interview Question Based on Full Outer...   Playlist to master SQL :    • Complex SQL Questions for Interview Prepar...   Rank, Dense_Rank and Row_Number:    • RANK, DENSE_RANK, ROW_NUMBER SQL Analytica...   #sql #dataengineer