instruction: Average Reputation Of SO Users where reputation > 1.
response: SELECT AVG(Reputation) AS AVG_REP, COUNT(Id) AS "total_users" FROM Users WHERE LOWER(Location) LIKE '%manchester, united kingdom' AND Reputation > 1