Table schema:
CREATE TABLE table (league_cup VARCHAR, r VARCHAR)

Question: How many times was the r 4?
SQL: SELECT COUNT(league_cup) FROM table WHERE r = 4