CGI Interview Question

Basic pyspark syntax and convert to sql.