Whenever you're ready, walk me through how you'd approach this.
Tell me about your experience with Scala, Spark, and SQL joins, and how you approach join correctness and performance.