-- Database schema
| Addresses : address_id [ INT ] primary_key , line_1 [ TEXT ] , line_2 [ TEXT ] , city [ TEXT ] , zip_postcode [ TEXT ] , state_province_county [ TEXT ] , country [ TEXT ] | People : person_id [ INT ] primary_key , first_name [ TEXT ] , middle_name [ TEXT ] , last_name [ TEXT ] , cell_mobile_number [ TEXT ] , email_address [ TEXT ] , login_name [ TEXT ] , password [ TEXT ] | Students : student_id [ INT ] primary_key Students.student_id = People.person_id , student_details [ TEXT ] | Courses : course_id [ TEXT ] primary_key , course_name [ TEXT ] , course_description [ TEXT ] , other_details [ TEXT ] | People_Addresses : person_address_id [ INT ] primary_key , person_id [ INT ] People_Addresses.person_id = People.person_id , address_id [ INT ] People_Addresses.address_id = Addresses.address_id , date_from [ TEXT ] , date_to [ TEXT ] | Student_Course_Registrations : student_id [ INT ] primary_key Student_Course_Registrations.student_id = Students.student_id , course_id [ INT ] Student_Course_Registrations.course_id = Courses.course_id , registration_date [ TEXT ] | Student_Course_Attendance : student_id [ INT ] primary_key Student_Course_Attendance.student_id = Student_Course_Registrations.student_id , course_id [ INT ] Student_Course_Attendance.course_id = Student_Course_Registrations.course_id , date_of_attendance [ TEXT ] | Candidates : candidate_id [ INT ] primary_key Candidates.candidate_id = People.person_id , candidate_details [ TEXT ] | Candidate_Assessments : candidate_id [ INT ] primary_key Candidate_Assessments.candidate_id = Candidates.candidate_id , qualification [ TEXT ] , assessment_date [ TEXT ] , asessment_outcome_code [ TEXT ] |
-- -- What are the ids of the students who registered for course 301?

SELECT student_id FROM student_course_attendance WHERE course_id  =  301;