Dataview Table sort by frontmatter doesn't work

[ush]

How about WHERE row["Author Name"] = "Name Example" instead of WHERE "Author Name" = "Name Example"?

See also:

@ush

By length(rows) AS "Count", you can re-label the length(rows) column as “Count”. But the scope of this new label “Count” is limited to the first line of the query (if I understand correctly), so you can’t reuse the “Count” label in another line. This is why SORT length(rows) DESC, not SORT Count DESC.