I'm starting another project and I'm currently designing our schema. I've got a couple many-to-many joins. I was wondering if a nested table is a better solution than simply creating an intersection ...

-- Execute a failing query (i.e. one which gives an error) to retrieve all employees records whose salary is lower than the average salary. Select * from Employees ...