如何提取和组合配置单元数据库中的特定数据表.发现一些错误

Question

SELECT
ps.hotel_id,
ps.name,
ps.country,
ps.city,
ps.chain_name,
ps.account_manager,
ps.adf_2_0,
t.booker_cc1,
sum(kpi.as_booked_roomnights) as ABRN,
sum(kpi.booked_roomnights) as BRN,
sum(kpi.cancelled_roomnights) as CRN,
sum(kpi.booked_price_euro) as booked_rev,
sum(kpi.stayed_roomnights) as SRN,
sum(kpi.stayed_price_euro) as stayed_rev,
sum(kpi.as_booked_commission_euro) as abc,
FROM reporting.kpi_booked_cancelled_stayed kpi
JOIN reporting.property_splits ps ON kpi.hotel_id=ps.hotel_id
JOIN fpa.transactions_detail t ON ps.hotel_id = t.hotel_id
where 
to_date(kpi.yyyy_mm_dd) BETWEEN '2020-01-01' AND '2020-01-05'
AND ps.region ='APAC'
AND ps.is_global_chain ='1'
AND ps.is_open_bookable ='1'
GROUP BY 1,2,3,4,5,6,7

嗨，我想从蜂箱里提取一些表格，然后把它们组合在一起。然而，我犯了一些错误。以下是我得到的：***编译语句时出错：失败：ParseException行17:0无法识别报告"的"FROM"附近的输入选择目标

Answer 1

此处添加逗号：

sum(kpi.as_booked_commission_euro) as abc,—删除逗号