Query to be build in pyspark

Job ID: 35898413

Budget: $10 – $30 USD

Please build a query in pyspark to create as shown in excel output
Related categories: Python Data Processing PySpark