总结MySQL查询结果的问题

Question

下面的查询返回附加图像中显示的内容。我认为非常简单的事情已经变得非常复杂了。我只想要做的就是将结果汇总到一行和一列中。在这种情况下，总数将是161。我该怎么做？我什么都试过了。我希望我已经提供了足够的信息。

​

​

SELECT
TRUNCATE
    (
        SUM(
            `assignment`.`percentage_achieved` *(
            SELECT
                `unitComponentWeighting`.`percentage_weighting` / 100
            FROM
                `unitComponentWeighting`
            WHERE
                `assignment`.`assignment_component_id` = `unitComponentWeighting`.`component_lookup_id`
            LIMIT 1
        )
        ),
        2
    ) AS `unit_percentage_grade`
FROM
    `assignment`
LEFT JOIN `assignmentType` ON `assignment`.`assignment_type_id` = `assignmentType`.`id`
LEFT JOIN `assignmentComponentLookup` ON `assignmentComponentLookup`.`id` = `assignment`.`assignment_component_id`
LEFT JOIN `unit` ON `unit`.`id` = `assignment`.`unit_id`
LEFT JOIN `assignmentSequence` ON `assignmentSequence`.`id` = `assignment`.`assignment_sequence_id`
LEFT JOIN `yearGroup` ON `yearGroup`.`id` = `unit`.`year_group_id`
WHERE
    `yearGroup`.`id` = 1
GROUP BY
    `assignment`.`unit_id`

Answer 1

尝试删除此部分“组由assignment.unit_id”