Assuming you are asking this query for Adobe Campaign Classic platform. you can group by the data based on creation date to get the one row for one day with processed and success count. Below are the steps you can follow.
1. Apply the toDate() function on creation date to remove the timestamp from date in output columns and check the group checkbox(Group=Yes)
2. Use aggregate function count() to get the count for processed and success count
3. In Advance Parameters, check the option 'Disable automatic adding of the primary keys of the targeting dimension'
Below is a screenshot for reference. Hope this helpful.