CREATE TABLE table_50443 ("Scorer" CLOB, "Club" CLOB, "League goals" CLOB, "FA Cup goals" CLOB, "League Cup goals" CLOB, "Total" FLOAT)

What is the sum of goals when the league cup goals are 4 and the FA cup goals are 0?
SELECT "Total" FROM table_50443 WHERE "League Cup goals" = '4' AND "FA Cup goals" = '0'
SELECT "Total" FROM "table_50443" WHERE "FA Cup goals" = '0' AND "League Cup goals" = '4'