Deloitte Interview Question

PyPark query, SQL query, Scenario based