1
TABLE WITHOUT ID
2
  category AS "分类",
3
  dateformat(file.ctime, "yyyy/MM/dd") AS "创建日期",
4
  file.link AS "本周笔记"
5
WHERE file.ctime >= date(today) - dur(3 days)
6
SORT category ASC, file.ctime DESC