Base Situation
- I got a table a containing a list of visits.
- Date, Location, add. Information
- Within another table b I am tracking daily stats
- Date, sum of hours invested, count of visits
Challenge
- How to generate "count of visits" in table b, counting up all the entries of table a, that have the same CREATED AT as the date in table b?
Thank you all upfront.