GamePlayed.points >= ANY(
   SELECT Points
   FROM GamePlayed GP
   WHERE GamePlayed.gameID = GP.gameID )

SELECT firstName, lastName, position, GamePlayed.gameID
FROM Player, Team, GamePlayed, Game, Tournament
WHERE Tournament.name = 'NCAA Division I'
AND Tournament.year = '2007'
AND Tournament.tourneyID = Game.tourneyID
AND GamePlayed.teamID = Team.teamID
AND GamePlayed.gameID = Game.gameID
AND Team.teamID = Player.teamID
AND Game.round = '6'
AND Player.firstYear <= '2007'
AND Player.lastYear >= '2007'
ORDER BY GamePlayed.points DESC
LIMIT 0,1

# Table `Player`
CREATE TABLE Player(
  firstName VARCHAR(20) NOT NULL,
  lastName VARCHAR(20) NOT NULL,
  firstYear INT(4) UNSIGNED NOT NULL,
  lastYear INT(4) UNSIGNED NOT NULL,
  teamID INT UNSIGNED NOT NULL
) ENGINE=InnoDB;

# Table `Game`
CREATE TABLE Game(
  gameID INT UNSIGNED NOT NULL,
  `round` INT UNSIGNED NOT NULL,
  tourneyID INT UNSIGNED NOT NULL
) ENGINE=InnoDB;

# Table `Tournament`
CREATE TABLE Tournament(
  tourneyID INT UNSIGNED NOT NULL,
  name VARCHAR(20) NOT NULL,
  `year` INT(4) UNSIGNED NOT NULL
) ENGINE=InnoDB;

# Table `GamePlayed`
CREATE TABLE GamePlayed(
  gameID INT UNSIGNED NOT NULL,
  teamID INT UNSIGNED NOT NULL,
  points INT UNSIGNED NOT NULL
) ENGINE=InnoDB;

# Table `Team`
CREATE TABLE Team(
  teamID INT UNSIGNED NOT NULL,
  name VARCHAR(20)
) ENGINE=InnoDB;

# Insert Player values.
INSERT INTO
Player(firstName,lastName,firstYear,lastYear,teamID)
VALUES
('Frank','Belini','2006','2007',1),
('Garry','Mocha','2006','2007',2),
('Fred','Astair','2006','2007',3);

# Insert Team values.
INSERT INTO team(teamID,name)
VALUES(1,'Conjugulars'),
(2,'Fatsos'),
(3,'White Lightning');

# Insert Tournament
INSERT INTO tournament(tourneyID,name,`year`)
VALUES(1,'First Tournament',2006);

# Insert two sorts of games for this tournament
INSERT INTO
game(gameID,`round`,tourneyID)
VALUES
(1,1,1),
(1,2,1),
(1,3,1),
(2,1,1),
(2,2,1),
(2,3,1);

# Insert what games have been played
INSERT INTO
GamePlayed(gameID,teamID,points)
VALUES
(1,1,20),
(1,2,47),
(1,3,52),
(2,1,82),
(2,2,17),
(2,3,111);

SELECT firstName, lastName, points, GamePlayed.gameID
FROM Player, Team, GamePlayed, Game, Tournament
WHERE Tournament.name = 'First Tournament'
AND Tournament.year = '2006'
AND Tournament.tourneyID = Game.tourneyID
AND GamePlayed.teamID = Team.teamID
AND GamePlayed.gameID = Game.gameID
AND Team.teamID = Player.teamID
AND Game.round = '3'
AND Player.firstYear <= '2006'
AND Player.lastYear >= '2006'
ORDER BY GamePlayed.points DESC