CREATE TABLE table_4106 ("Player" TEXT, "County" TEXT, "Matches" FLOAT, "Innings" FLOAT, "Runs" FLOAT, "Average" TEXT, "Highest Score" TEXT, "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'