Morgan Stanley interview question

Basic RDBMS questions on indexes, joins, group by, relational schema design.