Med-Metrix interview question

SQL Joins, procs, SSIS, Data Warehousing