CREATE TABLE Books (
    Book_ID INT, 
    Title TEXT,
    Author TEXT,
    Genre TEXT,
    Publication_Year INT);
-- desc Books;
INSERT INTO Books(Book_ID, Title, Author, Genre, Publication_Year)
VALUES(1, 'Harry Potter', 'J.K. Rowling', 'Fantasy', 1997),
    (2, 'The Jungle Book', 'Rudyard Kipling', 'Children', 1894),
    (3, 'Panchatantra', 'Vishnu Sharma', 'Children', 1983),
    (4, 'The Blue Umbrella', 'Ruskin Bond', 'Children', 1980),
    (5, 'Malgudi Days', 'R.K. Narayan', 'Children', 1943),
    (6, 'The Advanture of Tenali Raman', 'Kamla Laxman', 'Children',1994);
Select * from Books;

CREATE TABLE Students (
    student_id INT, 
    name TEXT,
    subject TEXT,
    marks INT);
INSERT INTO Students(student_id, name, subject, marks)
VALUES(1, 'Ardi', 'Math', 90),
    (2, 'Dila', 'Math', 85),
    (3, 'Sarah', 'Math', 87),
    (4, 'Rafli', 'Math', 78),
    (5, 'Rika', 'Math', 95);
Select * from Students;