CREATE TABLE table (r VARCHAR, position VARCHAR, AM VARCHAR, league VARCHAR)

If the position is AM and the league is larger than 7.0, what is the total R number?
SELECT COUNT(r) FROM table WHERE position = AM AND league > 7.0
SELECT COUNT("r") FROM "table" WHERE "AM" = "position" AND "league" > 7.0