SELECT ((lelang.hasil_lelang/lelang.hps)*100) AS hasil_lelang_per_hps
FROM lelang
WHERE (lelang.tahun_anggaran = '2021')
AND (lelang.tahun_anggaran BETWEEN '2000' AND '2024')
AND (lelang.tgl_pengumuman BETWEEN '2000-01-01' AND '2024-01-01')
AND
lelang.hasil_lelang > 0
GROUP BY lelang.kd_lelang
ORDER BY hasil_lelang_per_hps ASC