Where Did This Trade Come From? Attributing DEX Volume in Dune SQL

An adapted excerpt from The DeFi Data Quick-Start. dex.trades records every swap and tells you almost nothing about who sent it. Here is how to rebuild the missing field, starting with a query you can run right now.