TEKsystems interview question

MySQL questions on joins, aggregate functions, groupby, having etc