Table: giants_stats
Columns: year
rank
games
win
postseason

Question: What number of win% has a postseason of did not qualify and rank larger than 8?
SQL: SELECT COUNT("win") FROM giants_stats WHERE "postseason" = 'did not qualify' AND "rank" > 8

Question: What year ranked larger than 5?
SQL: SELECT "year" FROM giants_stats WHERE "rank" > 5

Question: What postseason has a win% between 0.40700000000000003 and 108 with a rank of 1?
SQL: SELECT "postseason" FROM giants_stats WHERE "win" > 0.40700000000000003 AND "games" < 108 AND "rank" = 1