Task: Using row to json() with Nested Joins in PostgreSQL

Task: Using row to json() with Nested Joins in PostgreSQL: a task in Terminal-Lego-15k (Harbor dataset). Write a PostgreSQL query that produces properly nested JSON output from joined tables using row to json() , where joined rows are represented as nested child objects without the intermediate f1…