先假設你要每兩個相加 SELECT (category_id-1)/2,SUM(data_value) FROM t GROUP BY (category_id...
我就不多問了。直接給你答案 SELECT a.加入日期,b.num AS 加入人數,c.num AS 退出人數 FROM db AS a LEFT JOIN (...
CREATE TABLE my_table ( Id varchar(20), Date_Join varchar(20), Date_Quit varchar...