CREATE TABLE table_name_40 (points INT, lost VARCHAR, goals_scored VARCHAR, goals_conceded VARCHAR)

How many points are there when they have under 27 goals scored, conceded 24 goals, and lost less than 6 times?
SELECT SUM(points) FROM table_name_40 WHERE goals_scored < 27 AND goals_conceded = 24 AND lost < 6
SELECT SUM("points") FROM "table_name_40" WHERE "goals_conceded" = 24 AND "goals_scored" < 27 AND "lost" < 6