- WITH badg AS
- (SELECT user_id,
- COUNT (id) OVER (PARTITION BY user_id) AS z
- FROM stackoverflow.badges
- )
- SELECT title
- FROM stackoverflow.posts AS p JOIN badg AS b ON p.user_id =b.user_id
- WHERE z>1000 AND title IS NOT NULL;
Title | Name | Language | When |
---|---|---|---|
Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re | Sharp Stork | text | 4 Months ago. |