fix(aggregation): adding tmp tables

[MR2011]

Task Description

Aggregation tables are used to precompute Vulnerability Counts and improve performance.

The procedures in migration 20251031095712 don't use tmp tables but truncate the aggregation tables. That leads to empty counts during computation time.

Acceptance Criteria:

• Add tmp tables