/* select u.DisplayName as dname, u.Reputation as rep, u...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Open Source Meta

Q&A about the site for people organizing, marketing or licensing open source development projects

-- Enter Query Title
-- Enter Query Description

-- Enter Query Title
-- Enter Query Description
/*
select u.DisplayName as dname,
       u.Reputation as rep,
       u.WebsiteUrl as weburl,
       u.Views as views,
       u.UpVotes as upvotes,
       p.Title as title
       from Users u, Posts p
       where p.OwnerUserId = u.Id;
*/
/*
select distinct DisplayName,
       count(Id) as Total_posts
       from (
         select u.Id as userId,
                p.Id as Id
                u.DisplayName as DisplayName
                from Users u, Posts p
                where u.Id = p.OwnerUserId
         ) x
group by DisplayName;
*/
select u.DisplayName as 'Display Name', count(p.Id) as Posts
from Users u, Posts p
where p.OwnerUserId = u.Id
group by u.DisplayName
having count(p.Id) > 150

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results