extensions/spark/kyuubi-spark-connector-tpcds/src/main/resources/kyuubi/tpcds_3.2/q43.sql [21:63]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
  sum(
    case
      when (d_day_name = 'Sunday') then ss_sales_price
      else null
    end
  ) sun_sales,
  sum(
    case
      when (d_day_name = 'Monday') then ss_sales_price
      else null
    end
  ) mon_sales,
  sum(
    case
      when (d_day_name = 'Tuesday') then ss_sales_price
      else null
    end
  ) tue_sales,
  sum(
    case
      when (d_day_name = 'Wednesday') then ss_sales_price
      else null
    end
  ) wed_sales,
  sum(
    case
      when (d_day_name = 'Thursday') then ss_sales_price
      else null
    end
  ) thu_sales,
  sum(
    case
      when (d_day_name = 'Friday') then ss_sales_price
      else null
    end
  ) fri_sales,
  sum(
    case
      when (d_day_name = 'Saturday') then ss_sales_price
      else null
    end
  ) sat_sales
from
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -



extensions/spark/kyuubi-spark-connector-tpcds/src/main/resources/kyuubi/tpcds_3.2/q59.sql [22:64]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
          sum(
               case
                    when (d_day_name = 'Sunday') then ss_sales_price
                    else null
               end
          ) sun_sales,
          sum(
               case
                    when (d_day_name = 'Monday') then ss_sales_price
                    else null
               end
          ) mon_sales,
          sum(
               case
                    when (d_day_name = 'Tuesday') then ss_sales_price
                    else null
               end
          ) tue_sales,
          sum(
               case
                    when (d_day_name = 'Wednesday') then ss_sales_price
                    else null
               end
          ) wed_sales,
          sum(
               case
                    when (d_day_name = 'Thursday') then ss_sales_price
                    else null
               end
          ) thu_sales,
          sum(
               case
                    when (d_day_name = 'Friday') then ss_sales_price
                    else null
               end
          ) fri_sales,
          sum(
               case
                    when (d_day_name = 'Saturday') then ss_sales_price
                    else null
               end
          ) sat_sales
     from
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -



