CGI Consultant interview questions

I was interviewed during the college recruiting process. I didn't have any experience and was still a senior in college getting my IT degree. I attended an interview day. It consisted of an HR presentation, three back-to-back interviews and a panel of current employees. During the back-to-back interviews, we were asked to write a simple SQL select statement. It wasn't a requirement of the job, but rather a preference. Other questions were mostly behavioral although one question really threw me off. 'tell me a joke' was not prepared for that one haha Very laidback