https://topbrochure.com/subquery-as-a-join-condition-in-databricks-sql-unity-catalo/