A readable query uses consistent formatting (one clause per line, indentation), explicit aliases, CTEs instead of deep nesting, and useful comments. It is easier to review, test and fix. Readability takes priority over brevity as long as performance does not rule it out.
Example
WITH commandes_2025 AS (...) -- one step, one clear name