idnr    | name | login | program | branch
------------+------+-------+---------+--------
 2222222222 | S2   | ls2   | Prog1   | B1
 3333333333 | S3   | ls3   | Prog2   | B1
 4444444444 | S4   | ls4   | Prog1   | B1
 1111111111 | S1   | ls1   | Prog1   |
(4 rows)

  student   | course | grade | credits 
------------+--------+-------+---------
 4444444444 | CCC111 | 5     |      10
 4444444444 | CCC222 | 5     |      20
 4444444444 | CCC333 | 5     |      30
 4444444444 | CCC444 | 5     |      40
 1111111111 | CCC111 | 3     |      10
 1111111111 | CCC222 | 3     |      20
 1111111111 | CCC333 | 3     |      30
 1111111111 | CCC444 | 3     |      40
 2222222222 | CCC111 | U     |      10
 2222222222 | CCC222 | U     |      20
 2222222222 | CCC444 | U     |      40
(11 rows)

  student   | course | credits 
------------+--------+---------
 4444444444 | CCC111 |      10
 4444444444 | CCC222 |      20
 4444444444 | CCC333 |      30
 4444444444 | CCC444 |      40
 1111111111 | CCC111 |      10
 1111111111 | CCC222 |      20
 1111111111 | CCC333 |      30
 1111111111 | CCC444 |      40
(8 rows)

  student   | course |   status   
------------+--------+------------
 1111111111 | CCC222 | registered
 3333333333 | CCC222 | waiting
 2222222222 | CCC222 | registered
 1111111111 | CCC111 | registered
 3333333333 | CCC333 | waiting
 2222222222 | CCC333 | waiting
 1111111111 | CCC333 | registered
(7 rows)

  student   | course 
------------+--------
 2222222222 | CCC111
 2222222222 | CCC333
 3333333333 | CCC555
(3 rows)

  student   | totalcredits | mandatoryleft | mathcredits | researchcredits | seminarcourses | qualified 
------------+--------------+---------------+-------------+-----------------+----------------+-----------
 3333333333 |            0 |             1 |           0 |               0 |              0 | f
 2222222222 |            0 |             2 |           0 |               0 |              0 | f
 4444444444 |          100 |             0 |          30 |              40 |              1 | t
 1111111111 |          100 |             0 |          30 |              40 |              1 | f
(4 rows)