0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Japanese language

SELECT p.OwnerUserId , COUNT(*) AS PostCount, u.DisplayName 
FROM Posts p
JOIN Users u ON p.OwnerUserId = u.Id
WHERE u.Location = 'Israel'
GROUP BY p.OwnerUserId, u.DisplayName 
ORDER BY PostCount DESC

fork query

edited feb 15 24

created feb 15 24 anonymous