0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for Muslims, experts in Islam, and those interested in learning more about Islam

Select u.Id, u.displayname, u.WebsiteUrl, u.reputation from Users u
--join Comments c on c.UserId = u.Id and c.Text like '%Spring Boot%'
where u.LastAccessDate > '2022-01-01'
AND (u.location like '%Germany%' 
OR u.location like '%Deutschland'
OR u.location like '%Switzerland'
OR u.location like '%Schweiz%'
OR u.location like '%Österreich%'
OR u.location like '%Austria%')
group by u.Id, u.displayname,u.LastAccessDate,u.WebsiteUrl,u.reputation 
ORDER BY u.LastAccessDate desc,u.reputation desc

fork query

edited mar 28

created mar 28 anonymous