as_sql_sample_data.txt

students table

id       name
1        Felix
2        John
3        Bob

assignments table

id       student_id      number      status
1        1               1           completed
2        1               2           completed
3        1               3           failed
4        1               4           completed
5        1               5           pending
6        2               1           failed
7        2               2           failed
8        2               3           completed
9        2               4           completed
10       3               1           failed
11       3               2           failed
12       3               3           failed
8        3               4           completed