RBC interview question

Basic questions about datawarehousing and SQL