Doris 4.0.0 through 4.0.3 reject `score()` predicates in `WHERE`, while
4.0.4 and later support direct minimum-score filtering. Document both
query forms in the English and Chinese dev/4.x relevance guides, with an
indexed sample table and input data. Explain supported score predicates,
threshold semantics, and the candidate limit required by the
older-version workaround. Fixes #3264.

The dev guides also describe the current implementation: an outermost
single-table query can compute and filter scores without Top-N, while a
scored SELECT nested in a subquery, view, CTE, or set operation still
needs score ordering and LIMIT. Update the activation conditions and FAQ
to match. The 4.x guides retain the Top-N requirement verified for 4.0.x
and 4.1.0 through 4.1.5.

Validation:
- Compared the score-filter implementation in the 4.0.0 through 4.0.4
release tags and 4.1.5-release, checked the 4.0.4 release notes and
[#60997](apache/doris#60997), and checked
current master’s `BindScoreToOlapScan` and regression examples from
[#69292](apache/doris#69292).
- All four pages pass MDX parsing after legacy HTML-comment removal,
front matter preservation, English/Chinese SQL example comparison, link
checks, locale/version sync checks, and `git diff --check`.
- No live cluster SQL or full website build was run. Existing page
routes, front matter, and navigation are preserved.

---------

Co-authored-by: morningman <[email protected]>