player | score1 | event <br /> -----------------------<br /> 7242 | 1.836 | 1<br /> 2535 | 2.353 | 1<br /> 7242 | 2.343 | 2<br /> 7242 | 1.343 | 3
select * from (select MIN(score1) as Your_score from event_team_player where player=7232 and score1>0) as t1, (select MIN(score1) as best,AVG(score1) as average,COUNT(distinct player) as no_of_player from event_team_player where score1>0) as t2, (select rank from (select player,rank() over(order by (avg(score1))) as rank from event_team_player where score1>0 group by player) as a where a.player=7232) as t3
Your_score | best | average | no_of_player | rank<br /> --------------------------------------------------<br /> 1.24 | 0.90 | 2.2323 | 1735 | 12
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)