This is incorrect. The "COUNT" function can not be used in "WHERE" clauses. The following would work:

SELECT name FROM users WHERE id IN (SELECT user_id FROM statuses GROUP BY user_id HAVING COUNT(user_id) > 1)