So, after about 30 minutes, the results finally showed up (wow that takes a long time). So I tried displaying just 2 columns (lastName, firstName) and this time it went much quicker.
So I did the next step and tried this SQL command
ExecuteSQL("SELECT DISTINCT s.lastName, s.firstName FROM student s WHERE studentNumber = '37972' ";"";"")
Now I am waiting again (it has been 10 minutes and counting).
What is going on?