CREATE TABLE table_name_74 (name VARCHAR, league_cup_apps VARCHAR, league_cup_goals VARCHAR, total_goals VARCHAR)

Who is the player that has scored more than 0 league cup goals, but has than 13 total goals, and 4 league cup appearances total?
SELECT name FROM table_name_74 WHERE league_cup_goals > 0 AND total_goals < 13 AND league_cup_apps = "4"
SELECT "name" FROM "table_name_74" WHERE "4" = "league_cup_apps" AND "league_cup_goals" > 0 AND "total_goals" < 13