An "Orders" table has $30$ columns, and the report only needs the order total by date. Which transformation should you perform?

Select an answer:

Filter the order amount field to not include blanks, and group by using the date column.

Remove the other columns. Group by using the date column and aggregate the appropriate total field.

Remove the other columns, and sort the date as descending.

Change the order total field data type, and remove the other columns.