A SQL table stores OrderDateTime but analysis needs daily sales totals. Which transformation is appropriate?

1. Convert to the intended reporting date and aggregate at that grain
2. Group by the full timestamp only
3. Join to an unrelated employee table
4. Use DISTINCT Amount only