Baselight
SELECT h.nama_hero, COUNT(p.id_hero) AS jumlah_pemilihan
FROM tabel_pemain p
JOIN tabel_hero h ON p.id_hero = h.id_hero
WHERE strftime('%Y', p.tanggal_pertandingan) = '2025'
GROUP BY h.nama_hero
ORDER BY jumlah_pemilihan DESC
LIMIT 10;

Share link

Anyone who has the link will be able to view this.