0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for SharePoint enthusiasts

SELECT 
  users.Id,
  users.Reputation,
  users.CreationDate,
  users.DisplayName,
  users.LastAccessDate,
  users.WebsiteUrl,
  users.Location,
  users.AboutMe,
  users.Views,
  users.UpVotes,
  users.DownVotes,
  users.ProfileImageUrl,
  users.EmailHash,
  users.AccountId
FROM users
LEFT JOIN posts 
  ON posts.OwnerUserId = users.Id
WHERE location LIKE '%Latvia%'
  AND users.views > 100
  AND posts.CreationDate > 2021
ORDER BY views DESC

fork query

edited apr 12

created apr 12 anonymous