I am on the final part of the Guided Project for SQL, specifically the Albums vs. Individual Tracks part.
I am just totally lost. I understand conceptually what is happening in all the queries, but up until now, I’ve been heavily relying on the solutions from other programmers and working backwards (I think I learn better and retain more that way).
On this particular query though, I just don’t know where to start. It asks us for the number of invoices, and percentage of invoices, so I know what it wants, but not how to begin.
What’s the first thing I should be attempting? For clarification, this isn’t a technical issue, but a thought-process issue. This SQL section has been infinitely harder than anything I’ve done thus far, and it’s really demotivating. I want to be able to get through this last part without looking at anyone’s answers, but it’s so confusing at times that I feel like it’s the only way.
Can anyone give some insight and/or guidance on this? It would be much appreciated.
Thank you very much!