A score below 40 is a fail. List student_id and fails (number of failed papers) for students with at least one fail. Ignore missing scores.
13 rows with columns student_id, fails — first 3 shown:
| # | ||
|---|---|---|
| 1 | 1 | 1 |
| 2 | 3 | 1 |
| 3 | 4 | 1 |
Run your code to see the output here.