Q&A for SharePoint enthusiasts
SELECT TOP 10* FROM users --LEFT JOIN posts --ON users.Id = posts.OwnerUserId WHERE location LIKE '%Latvia%' AND users.views > 100 --AND posts.CreationDate > 2021 ORDER BY views DESC