Tech Mahindra interview question

Case statements in both spark and sql