By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| student_id | student_name |
|---|---|
| 77 | Pepe LePew |
| student_id | course_id | percent_grade |
|---|---|---|
| 77 | 101 | 95.7 |
| 77 | 202 | 85.9 |
| 77 | 303 | 77.1 |
| 77 | 404 | 66.6 |
| from_percent | to_percent | letter_grade | GPA |
|---|---|---|---|
| 0 | 69 | F | 0 |
| 70 | 72 | C- | 1.67 |
| 73 | 76 | C | 2 |
| 77 | 79 | C+ | 2.33 |
| 80 | 82 | B- | 2.67 |
| 83 | 86 | B | 3 |
| 87 | 89 | B+ | 3.33 |
| 90 | 92 | A- | 3.67 |
| 93 | 96 | A | 4 |
| 97 | 100 | A+ | 4 |
| student_id | student_name | letter_grade | GPA |
|---|---|---|---|
| 77 | Pepe LePew | B- | 2.67 |