Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- user_id | item
- -------------------------
- 45 | camera
- 36 | smartphone
- 23 | camera
- 1 | glucose monitor
- 3 | smartwatch
- 2 | smartphone
- 7 | smartphone
- 2 | camera
- 2 | glucose monitor
- 2 | smartwatch
- user_id
- 2
- SELECT *
- FROM Information
- GROUP BY Information.user_id
- having count(DISTINCT item) >= 4
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement