Expedia Group interview question

Mostly on SQL queries, joins, optimization, spark, big data etc.