在添加联接和WHERE语句之前,我的查询可以工作。我需要从另一个表中加入id,以便只过滤我想要的行。有什么建议吗?我们很感激你的帮助。 SELECTMAX(CASE WHEN title = 'Listing ID' then value END) AS Listing,MAX(CASE WHEN title =
WITH H AS ( , SUM(CASE WHEN G.FFS = '-' THEN 1 ELSE 0 END) AS FFS_Dash, SUM(CASE WHEN G.FFS = 'Yes' THEN 1 ELSE 0 END) AS FFS_Yes
, SUM(CASE WHEN G.FFS = 'No'THEN 1 ELSE 0