• One benefit of breaking the query into temp tables is that allows the SQL writer to logically group related tables/data.

    For example, course-related tables/data could be grouped into 1 temp table and student-related tables/data could be grouped into a different temp table.

    Flattening the tables means that there are fewer decision points to understand how the data is being joined together.