Here is my tables [![enter image description here](https://i.stack.imgur.com/N2b6r.jpg)](https://i.stack.imgur.com/N2b6r.jpg)

My question is How to get CourseNames for a specific student id

I tried this but didn't work

```
select Course.CourseName from Course
where Course.CourseId in (

select Student.studentname ,StudentCourse.CourseId from Student inner join StudentCourse
on Student.StudentId = StudentCourse.StudentId
  where Student.StudentId = 1)

```

You can forget my query because i am new in SQL Server just tell me what exactly developers do in SQL Server real-world to get course names of a specific student