I have a vault named Notes
. Now I want to show the results sorted by the estimated word counts aliased Words Count
. But there is no change when I use the following DQL
.
TABLE file.ctime AS "Created Time", file.mtime As "Modified Time", round(file.size/3) AS "Words Count"
FROM "Notes"
SORT "Words Count" DESC