My issue
SELECT s.Student_Id AS St_id,
s.Student_Name AS St_Name,
s.Department,
s.Course_id,
c.Course_id,
c.Course_Name,
c.Credits,
c.Prof_id
FROM student s
JOIN course c ON s.Course_id = c.Course_id
WHERE s.Department = ‘Computer Science’;
Run time shows
My code
SELECT s.Student_Id AS St_id,
s.Student_Name AS St_Name,
s.Department,
s.Course_id,
c.Course_id,
c.Course_Name,
c.Credits,
c.Prof_id
FROM student s
JOIN course c ON s.Course_id = c.Course_id
WHERE s.Department = 'Computer Science';
Learning course: Database management systems
Problem Link: Inner Joins in Database management systems