Xactly Corp. interview question

SQL - union , joins , sub query etc ??