Subquery does not work in Databricks Community version?

THIAM_HUATTAN
Valued Contributor

‎12-26-2022 04:59 AM

I am testing some SQL code based on the book SQL Cookbook Second Edition, available from https://downloads.yugabyte.com/marketing-assets/O-Reilly-SQL-Cookbook-2nd-Edition-Final.pdf

Based on Page 43, I am OK with the left join, as shown here:

imageHowever, when I try with subquery below, it fails, why?

image

Preview file
34 KB
Preview file
74 KB