XL Dynamics interview question

SQL related (joins, groups,Aggregates, Subqueries.)