Q&A about the site for people organizing, marketing or licensing open source development projects
SELECT TOP 10* 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