问如何根据JSON日期范围减去两个JSON INT？

EN

SELECT
    userName,
    sum(entry_data ->> 'value') as totalValue,
    case when (entry_data ->> 'week1Value')::DATE BETWEEN '2022-07-25' AND '2022-07-31' 
             then sum(entry_data ->> 'value') AS week1 /* changed */
    case when (entry_data ->> 'week2Value')::DATE BETWEEN '2022-08-01' AND '2022-08-07' 
             then sum(entry_data ->> 'value') AS week2 /* changed */
FROM entry
group by userName /* changed */

with data as
  (select *, ceil(row_number() over (order by 0)::decimal/7)::integer rn 
  from entry)
select username,sum(to_number(entry_data->>'value','9999999')) total_value,
  sum (case when rn = 1 then
  to_number(entry_data->>'value','9999999')
  else 0
end) week_1_total,
sum (case when rn = 2 then
  to_number(entry_data->>'value','9999999')
  else 0
end) week_2_total
from data
group by username;

SELECT *
FROM   crosstab(
   'SELECT username, total_value,
    week_no, total_weekly
    FROM  (
        with data as (
            select e.username, e.rn week_no,
            (select sum(to_number(entry_data->>$$value$$,$$9999999$$)) 
            from entry) total_value,
            sum(to_number(entry_data->>$$value$$,$$9999999$$)) total_weekly
            from 
            (select *, 
            ceil(row_number() over 
            (partition by username order by 0)::decimal/7)::integer rn 
            from entry) e
            group by
            e.username, total_value, e.rn
            )
        select username,
        week_no,
        total_value,
        total_weekly
        from data
        union all
        select username,
        (select max(week_no) from data) + 
        row_number() over (partition by username order by 0),
        total_value,
        total_weekly - coalesce(lag(total_weekly) over (order by week_no), 0)
        from data ) x 
        ORDER  BY 1' 
        ,$$VALUES (1), (2), (3), (4), (5), (6)$$
   ) AS ct 
   ("username" text, 
   "total_value" int,
   "Week_1" int, 
   "Week_2" int, 
   "Week_3" int,
   "Weekdiff_1" int, 
   "Weekdiff_2" int, 
   "Weekdiff_3" int
);