SQL server Stuff with condition to PySpark

I have this sql server query:

SQL server Stuff with condition to PySpark

I have this sql server query:

SQL Stuff with condition to PySpark

I have this sql query: