ZS Associates interview question

case study based on SQL and ETL