Q&A for professional and enthusiast programmers
SELECT COUNT(u.id) AS UsersWithReputation FROM users u WHERE u.reputation > 0 AND u.reputation < 10 AND YEAR(u.creationDate) = 2023