From my own experience, SQL is solid. The problem that is see the most is the one we are taught in programming 101: atomic data. The information you seek above

From my own experience, SQL is solid. The problem that is see the most is the one we are taught in programming 101: atomic data. The information you seek above is computed and therefore justifies a view table instead of a "real one", because you really are doing something "complex". after that you can always select yourdata from yourview and you should be fine. Relational data can only be really efficient if its relational and sometimes, computed tables are also a nice thing to have but even better: sometimes a porgramm needs to aggregate the data periodically and put it into the database relationally.