CodeRunner question type: python3
A Python3 question type, which can handle write-a-function, write-a-class or write-a-program question types. For each test case, the student-answer code is executed followed by the test code. Thus, for example, if the student is asked to write a function definition, their definition will be executed first, followed by the author-supplied test code, which will typically call the function and print the result or some value derived from it.
If there are no standard inputs defined for all test cases, the question actually wraps all the tests into a single run, printing a separator string between each test case output. Please be aware that this isn't necessarily the same as running each test case separately. For example, if there are any global variables defined by the student code, these will hold their values across the multiple runs. If this is likely to prove a problem, the easiest work-around is to define one of the test case standard input fields to be a non-empty value - this forces CodeRunner into a fallback mode of running each test case separately.
SELECT benutzer.PNR, benutzer.Name, COUNT(*) AS Anzahl FROM benutzer, mitglied WHERE benutzer.PNR = mitglied.PNR GROUP BY benutzer.PNR, benutzer.Name