This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
A solution to last week’s challenge can be found here.
- Number of albums (Descending)
- Average rating based on all albums (Descending)
- Album title(s)
- Average number of reviews based on all albums (Descending)
- Year the first album was released
- Year the last album was released
Note: If in your solution you have null records for the Release Year, do not include them.
This challenge was updated to propose 2 start files and 2 solutions.
I was unable to locate any records with a Null release year using the following:
This obviously means my solution doesn't match but I'm happy with it I think - please correct me if I'm mistaken!
Still, a fantastic challenge for learning some alternative configs of the Summarise tool.
My Solution in attachment.
However! I have to disagreed wth the presented results (or I did not understand the objectivse) but in example of Artist "", in the expected output for this artst wa no Max date (last release date) and min was also wrong year.