Hello, the task is to convert the below SQL to pyspark (AWS Glue compatible). I need help converting a simple Redshift SQL statement to Pyspark (AWS Glue compatible). The query contains a join and nested sub-query. Please ping me to start work if you have the experience needed to resolve this task.