create table table_avg (
nickname varchar(10),
AVG_RESPONSETIME int);
 
insert into table_avg values ('cyber426',1);
insert into table_avg values ('neo927',1);
insert into table_avg values ('neo259',3);
insert into table_avg values ('cypher15',4);
insert into table_avg values ('fool28',5);
insert into table_avg values ('cyber974',6);
insert into table_avg values ('hacker285',6);
insert into table_avg values ('dau719',7);
insert into table_avg values ('trinity407',7);
insert into table_avg values ('fool380',8);
insert into table_avg values ('wiesel509',8);
insert into table_avg values ('dau814',10);
insert into table_avg values ('morpheus462',10);
insert into table_avg values ('neo517',10);
insert into table_avg values ('drago831',11);
insert into table_avg values ('drago861',13);
 
 
SELECT a.NICKNAME,
       a.AVG_RESPONSETIME,
       count(b.AVG_RESPONSETIME) + 1 - count(case (a.AVG_RESPONSETIME - b.AVG_RESPONSETIME) when 0 then 1 else NULL end) as rank
FROM table_avg a,
     table_avg b
WHERE b.AVG_RESPONSETIME<=a.AVG_RESPONSETIME
GROUP BY a.NICKNAME,
         a.AVG_RESPONSETIME HAVING count(b.AVG_RESPONSETIME) <=10
ORDER BY RANK ASC,
         a.NICKNAME ASC;
 

Y3JlYXRlIHRhYmxlIHRhYmxlX2F2ZyAoCm5pY2tuYW1lIHZhcmNoYXIoMTApLApBVkdfUkVTUE9OU0VUSU1FIGludCk7CgppbnNlcnQgaW50byB0YWJsZV9hdmcgdmFsdWVzICgnY3liZXI0MjYnLDEpOwppbnNlcnQgaW50byB0YWJsZV9hdmcgdmFsdWVzICgnbmVvOTI3JywxKTsKaW5zZXJ0IGludG8gdGFibGVfYXZnIHZhbHVlcyAoJ25lbzI1OScsMyk7Cmluc2VydCBpbnRvIHRhYmxlX2F2ZyB2YWx1ZXMgKCdjeXBoZXIxNScsNCk7Cmluc2VydCBpbnRvIHRhYmxlX2F2ZyB2YWx1ZXMgKCdmb29sMjgnLDUpOwppbnNlcnQgaW50byB0YWJsZV9hdmcgdmFsdWVzICgnY3liZXI5NzQnLDYpOwppbnNlcnQgaW50byB0YWJsZV9hdmcgdmFsdWVzICgnaGFja2VyMjg1Jyw2KTsKaW5zZXJ0IGludG8gdGFibGVfYXZnIHZhbHVlcyAoJ2RhdTcxOScsNyk7Cmluc2VydCBpbnRvIHRhYmxlX2F2ZyB2YWx1ZXMgKCd0cmluaXR5NDA3Jyw3KTsKaW5zZXJ0IGludG8gdGFibGVfYXZnIHZhbHVlcyAoJ2Zvb2wzODAnLDgpOwppbnNlcnQgaW50byB0YWJsZV9hdmcgdmFsdWVzICgnd2llc2VsNTA5Jyw4KTsKaW5zZXJ0IGludG8gdGFibGVfYXZnIHZhbHVlcyAoJ2RhdTgxNCcsMTApOwppbnNlcnQgaW50byB0YWJsZV9hdmcgdmFsdWVzICgnbW9ycGhldXM0NjInLDEwKTsKaW5zZXJ0IGludG8gdGFibGVfYXZnIHZhbHVlcyAoJ25lbzUxNycsMTApOwppbnNlcnQgaW50byB0YWJsZV9hdmcgdmFsdWVzICgnZHJhZ284MzEnLDExKTsKaW5zZXJ0IGludG8gdGFibGVfYXZnIHZhbHVlcyAoJ2RyYWdvODYxJywxMyk7CgoKU0VMRUNUIGEuTklDS05BTUUsCiAgICAgICBhLkFWR19SRVNQT05TRVRJTUUsCiAgICAgICBjb3VudChiLkFWR19SRVNQT05TRVRJTUUpICsgMSAtIGNvdW50KGNhc2UgKGEuQVZHX1JFU1BPTlNFVElNRSAtIGIuQVZHX1JFU1BPTlNFVElNRSkgd2hlbiAwIHRoZW4gMSBlbHNlIE5VTEwgZW5kKSBhcyByYW5rCkZST00gdGFibGVfYXZnIGEsCiAgICAgdGFibGVfYXZnIGIKV0hFUkUgYi5BVkdfUkVTUE9OU0VUSU1FPD1hLkFWR19SRVNQT05TRVRJTUUKR1JPVVAgQlkgYS5OSUNLTkFNRSwKICAgICAgICAgYS5BVkdfUkVTUE9OU0VUSU1FIEhBVklORyBjb3VudChiLkFWR19SRVNQT05TRVRJTUUpIDw9MTAKT1JERVIgQlkgUkFOSyBBU0MsCiAgICAgICAgIGEuTklDS05BTUUgQVNDOwo=