CREATE TABLE table (r VARCHAR, coppa_italia INT)

Name the total number of r for coppa italia larger than 1.0
SELECT COUNT(r) FROM table WHERE coppa_italia > 1.0
SELECT COUNT("r") FROM "table" WHERE "coppa_italia" > 1.0