duckdb.sql

CREATE OR REPLACE TABLE trains AS
FROM "http://blobs.duckdb.org/train_services.parquet";

FROM trains;

COPY (FROM trains) TO "./trains.csv";

FROM "./trains.csv";

SELECT * FROM read_csv_auto('user.csv', header=true);

CREATE TABLE tcs_bill_summary AS
SELECT * FROM read_csv_auto('/Users/fengj/Downloads/L3-明细账单/*.csv', 
  header=true,
  encoding='UTF-8',
  nullstr='-'
);

select count(*) from tcs_bill_summary;

select REPLACE("账单月", CHR(9), '') as "账单月","产品名称",sum("现金支付(元)") as "现金支付" from tcs_bill_summary group by "账单月","产品名称" order by "账单月";