mohankrishna02/interview-scenerios-spark-sql — reverse-engineered prompt

Build me a simple interview prep project for Spark SQL and PySpark scenario questions.

I want it to feel like a practical study repo, not a polished app. It should have around 30 plus common data interview problems using small sample tables, with the question, input data, expected output, and working solutions. Include examples like finding employees with the same salary, tracking order status changes, comparing sensor readings, counting customer addresses, and other real world data transformation questions.

Please create runnable PySpark scripts for each scenario, and also include Scala Spark solutions where it makes sense. Add a clear README with a table of contents so someone can jump to each scenario quickly. Each scenario should show the sample input and expected output in a readable table format, then link to or explain the solution.

Keep the data small and easy to understand. Make it useful for someone preparing for Spark, SQL, PySpark, or data engineering interviews. Look up current Spark docs online if needed.