Robosoft Technologies Interview Question

Given a table with columns campaign_id, date, and order_value, write a SQL query to calculate the total order value for each date.