main2groupby2

\BEGIN{TABLE}
    \caption {main2groupby2}
    \BEGIN{tabular}{|l|}
    \hline
    Main query BEFORE                                                                                                                                              \\ \hline
    SELECT ...\\    FROM ( SELECT ... FROM ...\\        JOIN ...\\      WHERE ...\\     UNION SELECT ... FROM...\\      WHERE ...\\     ) AS a10\\  GROUP BY GroupId, ModuleId \\   ) AS a12 \\ \hline
    Main query after                                                                                                                                               \\ \hline
    CREATE INDEX ... ON WorkRole(GroupID, ModuleID)\\\\SELECT ... FROM WorkRole \\WHERE ...\\   GROUP BY GroupId, ModuleId \\   ) AS a12                               \\ \hline
    \END{tabular}
\END{TABLE}