Pergunta de entrevista da empresa Robosoft Technologies

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