select distinct Users.DisplayName, Users.Location,

0

Please login or register to vote for this query.

(click on this box to dismiss)

Data Science Meta

Q&A about the site for Data science professionals, Machine Learning specialists, and those interested in learning more about the field

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://plus.google.com/s/', lower(replace(Users.DisplayName collate database_default, ' ', '+'))) as GooglePlusSearchUrl,

 

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 '%Poland%' or lower(Users.Location) like '%Polen%' or lower(Users.Location) like '%Krakow%' or lower(Users.Location) like '%cracow%'

 

) and

 

Tags.TagName in (

 

'java', 'scale'

 

)

AND Tags.TagName NOT in (

 

'c#','c++'

 

)

 

order by

 

Users.Reputation desc

Enter Parameters

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