php - 如何使用mySQL添加 'A' ,'B' ,'C'这样的分数

Question

你好我想咨询一下

如何使用 mysql QUERY 添加 A B C D 等分数

SELECT dcm_peserta.nm1, COUNT(siswa.nis) as jml, ROUND(dcm_peserta.nm1 / COUNT(dcm_peserta.nis) * 100) as percent

        /* add SELECT for scoring here */
FROM dcm_peserta, siswa
WHERE siswa.id_kelas = dcm_peserta.id_kelas AND dcm_peserta.id_kelas = '65'
GROUP BY dcm_peserta.nis

比如如果 percent = 0 得分 A，如果 percent = 1 until 20 得分 B

有什么想法吗？

Answer 1

当你在 php 中查询成绩时，只需使用字典来查找成绩:

$grades = array ( -1=>'A', 'B', 'C', 'D','E','F' );

for ($percentage=0; $percentage<=100; $percentage++) {
  $grade = $grades[floor(($percentage-1)/20)];
  echo sprintf("%s%% => %s\n", $percentage, $grade);
}