I have a db with one column indicating the name of a person, one column the task and a third with the year of that task:

Now I want to use sqlite to get it to show the total number of tasks per year per person and order it by year, so:

My request:

SELECT author, year, count(year) as tasks
FROM db
GROUP BY author, year
ORDER BY author, year ASC;

But this creates an order by author, not by year. Flipping author and year in the ORDER BY section doesn't work.

CodePudding user response：

If this "does not work"

 SELECT author, year, count(year) as tasks
 FROM db
 GROUP BY author, year
 ORDER BY year ASC, author;

try this

 SELECT author, year, tasks
 FROM (
   SELECT author, year, count(year) as tasks
   FROM db
   GROUP BY author, year
 ) X
 ORDER BY year ASC, author;