Invalid subquery: Scalar subquery must return only one column When i run this query in data bricks i get the following error
