MAQ Software Interview Question

SQL Joins, queries based on them