05-30-2018 10:53 AM
Making a lot of assumptions:
1. Filter data for a week
2. Remove possible duplicate visits per week
3. Count unique dates, if < 7 then they did not visit every day in a week.
vague questions = vague answers
hi, I have a sql question as below:
Given timestamps of visits, how to figure out how many people visit all seven days of a week on the location?