This is personal study note Copyright and original reference: https://www.youtube.com/watch?v=o3K572MC8Q0&list=PLuHgQVnccGMDF6rHsY9qMuJMd295Yk4sa ================================================================================ after denormalization (3 joins to 2 joins)