mysql - 在 SQL 中显示自生效日期起的包裹价格

Question

我正在尝试在图表上绘制收入以及上个月更改的套餐价格。如何更新套餐的价格。

     SELECT   TO_DATE(DATEADD(hh, -7, JSON_EXTRACT_PATH_TEXT(PROPERTY_HS_DATE_ENTERED_904938, 'value' ))) AS WIN_DATE_PST,
TO_VARCHAR(JSON_EXTRACT_PATH_TEXT(PROPERTY_PRODUCT_PURCHASED , 'value' )) AS PRODUCT_PURCHASED,
    
    
 

    case when close_date_pst < 'Sep 2 2021' then
            case 
                when PRODUCT_PURCHASED = 'Academy - Admissions' then 2997
                when PRODUCT_PURCHASED = 'Academy - Regular' then 1497
                when PRODUCT_PURCHASED = 'Support Monthly' then 152.52
                when PRODUCT_PURCHASED = 'Information Monthly' then 152.52
                when PRODUCT_PURCHASED = 'Academy - Monthly' then 152.52
                when PRODUCT_PURCHASED = 'Consulting Monthly' then 152.52
                else
                  case 
                   when PRODUCT_PURCHASED = 'Academy - Admissions' then 3146.85
                   when PRODUCT_PURCHASED = 'Academy - Regular' then 2096.85
                   when PRODUCT_PURCHASED = 'Support Monthly' then 160.15
                   when PRODUCT_PURCHASED = 'Information Monthly' then 160.15
                   when PRODUCT_PURCHASED = 'Academy - Monthly' then 160.15
                   when PRODUCT_PURCHASED = 'Consulting Monthly' then 160.15
            end as REVENUE
        FROM XYZ

我相信我没有以正确的格式放置日期过滤器。这段代码对我不起作用。

标签： mysqlsql