I wrote about how to solve with SQL. https://noborus.github.io/blog/jqsql/