計算每週的記錄數

SELECT date_trunc（‘week’，<>）ASWeek，count（*）FROM <> GROUP BY 1 ORDER BY 1;