a sql question

[flyingsohigh]

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?

Thanks.

[Reeza]

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

---

@flyingsohigh wrote:

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?

Thanks.

---