Stale on purpose
A materialized view is a snapshot. Add an order on a new day and compare the view with the live data. Return the view's row count as mv and the live distinct-day count as live.
task
Insert an order for 2027-01-01, then show the matview's row count next to the live distinct-day count (they differ until refreshed).