Hello,
This seems like a SparkSQL question more than a Dataiku DSS one 😉
A quick google search yields this StackOverflow question:Does SparkSQL support subquery?
as well as the SPARK-4226 ticket.