Why do these two aggregations produce different results on the same field?

I suppose these two aggregations produce same results. However, they don’t.

The min normalized_rating is 1.001532443626323 produced by following query.

The min normalized_rating is 1.0507662218131615 produced by following query.

Welcome @HD_07513

Please tidy up your code with proper indentation by enclosing it in HTML pre tags or backticks like the image below:

PS: At quick glance this looks very much like 90% of a lab answer. If it is, it’s against forum guidelines to post potential answers to labs. Please edit your post and strip it right back to an example that doesn’t resemble a lab answer.

Hi @HD_07513,

Please check your discourse inbox for detailed explanation.

I have edited your post and removed the pipelines as it would give away hints to our other learners.

Please let me know, if you have any questions.