How many users whose reputations are higher than 2000 and the number of views is higher than 1000?
reputations are higher than 2000 refer to Reputation > 2000; number of views is higher than 1000 refers to Views > 1000;
SELECT COUNT(id) FROM users WHERE Reputation > 2000 AND Views > 1000