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.