question: What is the sum of the scottish cup of the forward player with less than 2 league cups and a total greater than 6?
answer: SELECT SUM(scottish_cup) FROM table_name_47 WHERE league_cup < 2 AND total > 6 AND position = "forward"
context: CREATE TABLE table_name_47 (scottish_cup INTEGER, position VARCHAR, league_cup VARCHAR, total VARCHAR)