OnMobile interview question

Joins, normalization, group by queries.