Comment by ieee2

LIMIT not working. Try:

SELECT whiteRating, blackRating FROM ChessGames WHERE gameWinner='black' LIMIT 2 OFFSET 8;