Table: great_danes_basketball_stats
Columns: rank
player
years
games
ast_avg
total_assists

Question: How many assists for player(s) with over 107 games and ranked less than 2?
SQL: SELECT COUNT("total_assists") FROM great_danes_basketball_stats WHERE "games" > 107 AND "rank" < 2

Question: What is the total number of assists for players with under 55 games and over 6 assists per game average?
SQL: SELECT SUM("total_assists") FROM great_danes_basketball_stats WHERE "ast_avg" > 6 AND "games" < 55

Question: What is the average rank for players with less than 2.9 Assists per game?
SQL: SELECT AVG("rank") FROM great_danes_basketball_stats WHERE "ast_avg" < 2.9