users have a reputation greater than 0 and less than 10, who joined the platform in 2023?

0

Please login or register to vote for this query.

(click on this box to dismiss)

Code Review

Q&A for peer programmer code reviews

select count(*) from users
join posts on users.id = posts.owneruserid
where users.reputation > 0 
and users.reputation < 10
and users.creationdate >= 2023-01-01
and users.creationdate <= 2023-12-31

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results