Help me in solving GSQ62 problem

help
,
1

My issue

/* Write a query to join the tables ‘student’ and ‘course’ and output the same. Check if you can find the course with id ENG201 in the output */

My code

/* Write a query to join the tables 'student' and 'course' and output the same. Check if you can find the course with id ENG201 in the output */
SELECT 
    s.St_id, 
    s.St_Name, 
    s.Department, 
    c.Course_id, 
    c.Course_Name, 
    c.Credits, 
    c.Prof_id
FROM 
    student s
INNER JOIN 
    course c ON s.St_id = s.St_id;

Learning course: Database management systems
Problem Link: Inner Joins in Database management systems

2

SELECT St_id AS St_id, – Replace ‘ID’ with the correct column name
St_Name AS St_Name,
student.Department,
student.Course_id,
course.Course_id,
course.Course_Name,
course.Credits,
course.Prof_id
FROM student
INNER JOIN course ON student.Course_id = course.Course_id;