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', 8),
    (4, 'Emily', 'Brown', 7),
    (5, 'Alice', 'Jackson', 9);
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;
UPDATE Students SET Grade=7 WHERE StudentID=6;
SELECT *FROM Students;
SELECT marks FROM Result WHERE StudentID=5;
UPDATE Result SET Marks=25 WHERE StudentID=3;
select *from Result;
DELETE FROM Students WHERE StudentID=3;
select *from Students;
SELECT *FROM Students WHERE Grade>7;
SELECT *FROM Result WHERE Subject='Coding';
SELECT StudentID, Marks FROM Result WHERE Subject='Coding';
INSERT INTO Students(StudentID, FirstName, LastName, Grade)VALUES(3, 'Michael', 'Johnson', 7);
SELECT *FROM Students;