Software Developer

0

Please login or register to vote for this query.

(click on this box to dismiss)

Electrical Engineering

Q&A for electronics and electrical engineering professionals, students, and enthusiasts

select distinct
Users.DisplayName,
Users.Location,
Users.CreationDate as RegistrationDate,
Users.LastAccessDate,
Users.Reputation,
Users.Views,
concat('https://stackoverflow.com/users/', Users.Id) as ProfileUrl,
Users.WebsiteUrl,
concat('https://www.google.com/search/?q=', 
lower(replace(Users.DisplayName collate database_default, ' ', 
'+'))) as GoogleSearchUrl,
concat('https://github.com/search?type=Users&q=', 
lower(replace(Users.DisplayName collate database_default, ' ', 
'+'))) as GitHubSearchUrl,
concat('https://www.linkedin.com/vsearch/p?keywords=', 
lower(replace(Users.DisplayName collate database_default, ' ', 
'+'))) as LinkedInSearchUrl,
concat('https://twitter.com/search?mode=users&q=', 
lower(replace(Users.DisplayName collate database_default, ' ', 
'+'))) as TwitterSearchUrl
from
Users
inner join Posts as Answers on Answers.OwnerUserId = Users.Id and
Answers.PostTypeId = 2 and
Answers.Score >= 1
inner join Posts as Questions on Questions.Id = Answers.ParentId
inner join PostTags on PostTags.PostId = Questions.Id
inner join Tags on Tags.Id = PostTags.TagId
where
Users.Reputation >= 500 and
Users.LastAccessDate >= dateadd(month, -3, getdate()) and
(
lower(Users.Location) like '%united states%' or 
lower(Users.Location) like '%usa%' or lower(Users.Location) like 
'%nyc%' or lower(Users.Location) like '%new york%'
) and
Tags.TagName in (
'Java'
)
order by
Users.Reputation desc

Enter Parameters

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