BNSF Railway interview question

Heavy PySpark coding rounds, sql