Table: players_stats_3
Columns: rank
name
period
games
goals

Question: What is the name of the person with more than 299 games during the 1995–07 period?
SQL: SELECT "name" FROM players_stats_3 WHERE "games" > 299 AND "period" = '1995–07'

Question: What is the number of games for Shlomi Avrahami?
SQL: SELECT COUNT("games") FROM players_stats_3 WHERE "name" = 'shlomi avrahami'

Question: What is the rank for the period of 1973–89, with less than 423 games.
SQL: SELECT SUM("rank") FROM players_stats_3 WHERE "period" = '1973–89' AND "games" < 423