a sql question

flyingsohigh — Wed, 30 May 2018 14:39:30 GMT

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.

Re: a sql question

Reeza — Wed, 30 May 2018 14:53:11 GMT

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.

topic Re: a sql question in SAS Programming

a sql question

Re: a sql question