I'm not so experienced at all and i have difficulties writing a complicated query. After taking me whole yesterday i decided not to lose any more nerves, but to ask for help
here is the table.
CREATE TABLE trivia_results (
player_id int(10) unsigned NOT NULL,
points smallint(5) unsigned NOT NULL ,
game_date_end int(10) unsigned NOT NULL,
answered_questions tinyint(3) unsigned NOT NULL
in this table i keep records for player results for a trivia game.
game_date_end is for PHP timestamp. A sampe row is
player_id points game_date_end answered_q
1 625 1036952313 5
So the query i can't write must make a standing. It should take the last 10 games average points for a player and to
order the players in a standing proper way.
if somebody can help me, i'll greatfull.
Best Regards Ivan Kostov