WorkRole

\BEGIN{TABLE}
    \caption {WorkRole}
    \BEGIN{tabular}{|l|}
    \hline
    Main query BEFORE                                                                                                                                                                                                                                                                                                                                                                                                      \\ \hline
    SELECT GroupId, ModuleId, MAX(IsStudent) AS IsStudent, MAX(IsApprover) AS IsApprover \\ FROM ( \\       SELECT a11.GroupId, ModuleId, 1 AS IsStudent, 0 AS IsApprover \\        FROM Students AS a11\\      JOIN RelGroupsModules USING(GroupId) \\     WHERE PersonId = 1 \\       UNION SELECT GroupId, ModuleId, 0 AS IsStudent, 1 AS IsApprover \\      FROM Approvers AS a9\\      WHERE PersonId = 1 \\       ) AS a10\\  GROUP BY GroupId, ModuleId  \\ \hline
    Main query after                                                                                                                                                                                                                                                                                                                                                                                                       \\ \hline
    SELECT GroupId, ModuleId, IsStudent, IsApprover\\   FROM WorkRole \\    WHERE PersonID = 1\\    GROUP BY GroupId, ModuleId                                                                                                                                                                                                                                                                                                  \\ \hline
    \END{tabular}
\END{TABLE}