Who is the player who has a total less than 4, no scottish cups, and a league cup greater than 0?
CREATE TABLE table_name_31 (
    player VARCHAR,
    league_cup VARCHAR,
    total VARCHAR,
    scottish_cup VARCHAR
)
SELECT player FROM table_name_31 WHERE total < 4 AND scottish_cup = 0 AND league_cup > 0
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Who is the player who has a total less than 4, no scottish cups, and a league cup greater than 0? ### Input: CREATE TABLE table_name_31 (
    player VARCHAR,
    league_cup VARCHAR,
    total VARCHAR,
    scottish_cup VARCHAR
) ### Response: SELECT player FROM table_name_31 WHERE total < 4 AND scottish_cup = 0 AND league_cup > 0