Table: red_dragons_soccer_2007
Columns: number
name
games_played
games_started
goals
assists
points
shots

Question: How many games played catagories are there for Lauren McGee? 
SQL: SELECT COUNT("games_played") FROM red_dragons_soccer_2007 WHERE "name" = 'Lauren McGee'

Question: How many numbers belong to the player with 10 assists? 
SQL: SELECT COUNT("number") FROM red_dragons_soccer_2007 WHERE "assists" = 10

Question: How many names are listed for the player with 50 points?
SQL: SELECT COUNT("name") FROM red_dragons_soccer_2007 WHERE "points" = 50