Make report of sales

Hello, I am creating and app, and I have a part that I want to report on the user how much money he made today. I have a row on my database with pricing but I don’t know how I can separate the income by date and also how I can sum all the rows of my prices in database.