A daily revenue query should produce one row per region and day. Which operation is required?

1. Select DISTINCT revenue only
2. Cross join each transaction with all days
3. Group by region and day, then aggregate revenue
4. Order by revenue only