Function is_avg_window_function

engine/src/parser/expression_utils.cpp:694–699

Due to `avg` window aggregation the OVER clause is repeated three times from Calcite something like: CAST(/(CASE(>(COUNT($0) OVER (PARTITION BY $1), 0), $SUM0($0) OVER (PARTITION BY $1), null:INTEGER), COUNT($0) OVER (PARTITION BY $1))):INTEGER

// something like:
// CAST(/(CASE(>(COUNT($0) OVER (PARTITION BY $1), 0), $SUM0($0) OVER (PARTITION BY $1), null:INTEGER), COUNT($0) OVER (PARTITION BY $1))):INTEGER
bool is_avg_window_function(std::string expression) {
	size_t num_over_clauses = StringUtil::findAndCountAllMatches(expression, "OVER");
	if (num_over_clauses == 3) return true;
	
	return false;
}

// input: max_prices=[MAX($0) OVER (PARTITION BY $2 ORDER BY $0, $1)]
// output: max_prices=[MAX($0)]