Create TABLE Students (
    StudentID INT PRIMARY KEY,
    FirstName VARCHAR(50),
    LastName VARCHAR(50),
    Grade INT
);

CREATE TABLE Result(
    StudentID INT PRIMARY KEY,
    Subject VARCHAR(50),
    Marks INT
);
INSERT INTO Students (StudentID, FirstName, LastName, Grade) VALUES
    (1, 'John', 'Doe', 7),
    (2, 'Jane', 'Smith', 7),
    (3, 'Michael', 'Johnson', 7),
    (4, 'Emily', 'Brown', 7),
    (5, 'Alice', 'Jackson', 7);

INSERT  INTO Result (StudentID, Subject, Marks) VALUES
    (1, 'coding', 22),
    (2, 'coding', 23),
    (3, 'Science', 20),
    (4, 'English', 25),
    (5, 'French', 24);

SELECT * FROM Students WHERE Grade = 7;
SELECT COUNT(*) FROM Students WHERE Grade = 7;
SELECT * FROM Students WHERE StudentID = 2;
INSERT INTO Students (StudentID, FirstName, LastName, Grade) VALUES
(6, 'David', 'Wilson', 8);
SELECT * FROM Students;