1. StackOverflow 文档
  2. postgresql 教程
  3. 日期，时间戳和间隔
  4. 计算每周的记录数

计算每周的记录数

Created: November-22, 2018

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