CGI interview question

Basic pyspark syntax and convert to sql.