計算每週的記錄數

SELECT date_trunc(‘week’,<>)ASWeek,count(*)FROM <> GROUP BY 1 ORDER BY 1;