Roles and permissions

Hello,

I need to create a report about who and when add a user as student role in a course with the following columns:
user name
course name
student name
date added

May I know whether these information can be pulled out by a SQL query through database without doing any PHP programming?

Your reply is appreciated.

Regards,

Shirley