SELECT 
	Ortalama.*, (@sira:=@sira+1) as Sira
FROM 
	(SELECT Okul, AVG(Turkce) as Turkce, AVG(Matematik) as Matematik, AVG(FenBilgisi) as FenBilgisi, Ilce FROM notlar Group By Okul ORDER BY Turkce DESC) as Ortalama, 
	(SELECT @sira:=0) as Siralama
Order By Sira ASC;

SELECT  
    Ortalama.*, (@sira:=@sira+1) as Sira 
FROM  
    (SELECT AVG(turkce) as turkce, AVG(matematik) as matematik, AVG(fenvetek) as fenvetek FROM veri Group By kurum_kodu ORDER BY turkce DESC) as Ortalama,  
    (SELECT @sira:=0) as Siralama 
Order By Sira ASC;