Code not working

[teoryan2]

I am trying to replicate one of the dataview templates in Obsidian Forum from @Arminta, and I have followed her code exactly as shown below

TABLE Status, length(tasks) AS Total, sum(tasks.completed) AS Completed, sum(tasks.completed) / (length(tasks)) * 100 + "%" AS Progress, tasks[0] AS "Next", file.mtime AS "Modified"
FROM #projects
SORT file.mtime ASC

However, when switched to preview mode, I got this error message:

May I know what is done wrongly here? Any help will be greatly appreciateed!

[blacksmithgu]

Replace all of your instances of tasks with file.tasks, and it should work. tasks is not a Dataview implicit field, file.tasks is probably what you are looking for.