Move optimizer rule that has aggregate function out of core

[jayzhan211]

Is your feature request related to a problem or challenge?

Part of #8708
The background is that we are moving builtin aggregate function to functions-aggregate as an UDAF

While moving count to UDAF, I found that we need to call UDAF in the optimize rule single_distinct_to_groupby.
I think we need to move the rule that has aggregate function out of the core because the optimizer is the core of the datafusion that we would like to prevent importing the functions-aggregate crate

Describe the solution you'd like

Optimizer

Move common optimizer things to optimizer-common crate or datafusion-expr crate
Move rules to functions-aggregate

• single_distinct_to_groupby
• common_subexpr_eliminate
• decorrelate
• replace_distinct_aggregate

Analyzer

• count_wildcard_rule // This should be similar to Add FunctionRewrite API, Move Array specific rewrites to datafusion_functions_array #9583

Describe alternatives you've considered

No response

Additional context

No response

[alamb]

What part of the rule was aggregate specific?

I think the single distinct aggregate removal rule is general to all aggreagetes (it isn't aggregate specific) including user defined ones so I am not sure we need to move the rules.

BTW this PR is updating single distinct aggregate rule #10460

[jayzhan211]

I thought I need to import functions-aggregate to create new aggregate function expression, but I found out that I could just modify AggregateFunction directly, since the function does not change.

[jayzhan211]

let me close the issue first