Thanks for the post, I had two objectives here from the large data collection.

One was multiple visits (gt 2) and the other was to have a score above 4.

I was...

Solution

...

Tried to use

where (a.totvisitists > 1 or b.score > 3)

but I wanted to pick up all the rows from the first id, not just the scores >3