Flipside Challenge 01

I just recently joined MetricsDAO and found this initial Flipside Challenge to get started with on-chain analytics. Although one is pretty well guided through the process of creating their first queries, visualizations and dashboards I had the feeling that there are already a lot of very specific SQL terms used which are not explained well enough in the tutorial. Therefore, the aim of this board is to guide a newbie through this first challenge in a way to maximize the knowledge one can take away from it. As a reference, here is the challenge: https://teamflipside.notion.site/Ethereum-1-Ethereum-Core-Table-Walkthough-Swaps-290ad820a4724c2b97425da1b948ed51