Столбец недопустим в списке выбора

SELECT *, marks.ID, marks.mark
FROM students
JOIN marks ON students.ID = marks.student_id
JOIN subjects_semestr ON subjects_semestr.ID=marks.subject_semestr_id
JOIN semestr ON semestr.ID = subjects_semestr.semestr_id
WHERE semestr.name='1'
HAVING COUNT(marks.student_id)>2

GROUP BY students.ID
HAVING COUNT(students.ID)>2

CREATE TABLE subjects
(
    ID INT NOT NULL IDENTITY(1,1) PRIMARY KEY,
    [name] VARCHAR(50) NOT NULL,
    hours INT NOT NULL
);
CREATE TABLE semestr
(
    ID INT NOT NULL IDENTITY(1,1) PRIMARY KEY,
    [name] VARCHAR(50) NOT NULL
);
CREATE TABLE students
(
    ID INT NOT NULL IDENTITY(1,1) PRIMARY KEY,
    surname VARCHAR(50) NOT NULL,
    Birthday DATE,
    KURS INT NOT NULL DEFAULT 1
);
GO
CREATE TABLE subjects_semestr
(
    ID INT NOT NULL IDENTITY(1,1) PRIMARY KEY,
    semestr_id INT NOT NULL,
    subject_id INT NOT NULL,
    CONSTRAINT semestr_id_fk
    FOREIGN KEY(semestr_id)
    REFERENCES semestr(ID),
    CONSTRAINT subject_id_fk
    FOREIGN KEY(subject_id)
    REFERENCES subjects(ID)
);
 
CREATE TABLE marks
(
    ID INT NOT NULL IDENTITY(1,1) PRIMARY KEY,
    student_id INT NOT NULL,
    subject_semestr_id INT NOT NULL,
    mark INT NOT NULL,
    CONSTRAINT subject_semestr_id_fk
    FOREIGN KEY(subject_semestr_id)
    REFERENCES subjects_semestr(ID),
    CONSTRAINT student_id_fk
    FOREIGN KEY(student_id)
    REFERENCES subjects(ID)
);

SELECT students.ID,students.surname, marks.ID, marks.mark

HAVING COUNT(students.ID)>2