Support delete/gc the pre-aggregation tables when all related deployments are dropped

**Describe the feature you'd like**

When deployments are dropped, there is no action for the associated pre-aggregation tables.

**Additional context**

We may maintain a counter for every pre-aggregation table. Decrease the counter when one deployment drops. When it reaches zero, users may issue a `gc` command to finally delete the tables.