MAQ Software interview question

SQL Joins, queries based on them