We'll count the regulars that visited today and sum up the drinks all of them bought.

Run the query to get a preview.