Bitki puan sırası

bitki_puan_sira.sql

SELECT
  t.bid, t.badi, t.averaj, t.sira
FROM (
	SELECT b.bid, b.badi, p.averaj, @sira := @sira + 1 AS sira
	FROM bitki b
	JOIN (SELECT @sira := 0) r
	INNER JOIN (SELECT bid,AVG(puan) averaj FROM puanlar GROUP BY bid) p ON p.bid=b.bid
	ORDER BY p.averaj DESC
) t
WHERE t.bid = 3;