We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
As my colleague pointed it out, records with multiple authors are separated by an "and" and a "with". So there is a slight difference in the total number of weeks and the total count of books.
Hi! Nice challenge! Here my solution 🙂
By the way, the provided solution is inaccurate; for example, James Patterson should sum 200 weeks instead of 195, because the provided solution hasn't taken into account the 5 weeks of the books that have a "with" word in the "author" field...
Doesn't look like the recommended output accounted for this, but I applied fuzzy matching to the split author names to account for inconsistent formatting. It did result in a small increase to the data that made it into the chart.