CREATE TABLE table_4106 ("Player" CLOB, "County" CLOB, "Matches" FLOAT, "Innings" FLOAT, "Runs" FLOAT, "Average" CLOB, "Highest Score" CLOB, "100s" FLOAT, "50s" FLOAT)

What is the average for the player from Lancashire 1 100?
SELECT "Average" FROM table_4106 WHERE "County" = 'Lancashire' AND "100s" = '1'
SELECT "Average" FROM "table_4106" WHERE "100s" = '1' AND "County" = 'Lancashire'