SQL 如何让一列自动扩展？

WITH rq_values AS (
  SELECT DISTINCT RQ FROM your_table
),
werks_values AS (
  SELECT DISTINCT WERKS FROM your_table WHERE WERKS IN (2021, 2022, 2023)
)
SELECT
  rq_values.RQ,
  werks_values.WERKS,
  COALESCE(your_table.JE, 0) AS JE
FROM
  rq_values,
  werks_values
LEFT JOIN
  your_table
ON
  your_table.RQ = rq_values.RQ AND
  your_table.WERKS = werks_values.WERKS
ORDER BY
  rq_values.RQ, werks_values.WERKS