Hello all, I'm looking to create a SQL query that gives me the following:
1. User Name
2. Course Taken
3. Current Courses (Both Complete and Not Complete)
3. Date Course Completed
4. Department of the User
I did a preliminary query, but I must be using the wrong tables because my current courses doesn't show. Has anyone done a query similar to this? What tables did you focus on?