-- create a student table
CREATE TABLE Students (
    StudentID INT PRIMARY KEY,
    FirstName VARCHAR(50),
    LastName VARCHAR(50),
    Grade INT
);

-- Create a result table
CREATE TABLE Result(
    StudentID INT PRIMARY KEY,
    Subject VARCHAR(50),
    Marks INT
);

-- Insert data into Students table
INSERT INTO Students (StudentID, FirstName, LastName, Grade)
VALUES
(1, 'John', 'Doe', 10),
(2, 'Wolly', 'Charman', 9),
(3, 'Shriyan Reddy', 'Kallem', 7);

-- Insert data into Students table
INSERT INTO Result (StudentID, Subject, Marks)
VALUES
(1, 'Maths', 89)
(2, 'Chemistry', 78)
(3, 'Coding', 100)

-- Basic SQL Queries for School Data
-- Select all Grade 7 students:
SELECT * FROM Students WHERE Grade = 7;

-- Count the number of Grade 7 students:
SELECT COUNT(*) FROM Students WHERE Grade = 7;