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)