Here is my another guided project using SQL. This time I finally managed to insert some graphs into it, thanks to a valuable advice of @WilfriedF (well, Wilfried, it’s already the second time when your suggestions help me to significantly improve my projects, many thanks! )
After my first SQL project, the queries of this second one seemed not so easy at all. Then, this time I tried to follow more strictly the SQL style guide, so I’m more happy with how my code looks now, much tidier.
This time a surprising finding for me was that almost half of the Chinook store’s unique tracks were never sold. Also, that there are artists who are present in many playlists, but whose tracks are related to one of the least popular genre. Chinook definitely has to do something to improve this situation and to increase their profit. Well, I remember that the store is actually fictional, but I’m impressed anyway!
As usual, any feedback and positive criticism from you is very welcome. Please let me know whether you agree with my findings, what can be improved and if there’s something I’m missing in this project.
Looking forward to seeing your comments and suggestons.
Thanks a lot!