CREATE TABLE Books (
    Book_ID INT,
    Title TEXT,
    Author TEXT,
    Genre TEXT,
    Publication_Year INT
);
INSERT INTO Books (Book_ID, Title, Author, Genre, Publication_Year)
VALUES
(1, 'The Jungle Book', 'Rudyard Kipling', 'Children', 1894),
(2, 'Panchatatantra', 'Vishnu Sharma', 'Action', 1983),
(3, 'The Blue Umbrella', 'Ruskin Bond', 'Children', 1980),
(4, 'Malgudi Days', 'R.K. Narayan', 'Horror', 1943),
(5, 'The Advntures of Tenali Raman', 'Kamala Laxman', 'Children', 1994);
-- SELECT * FROM Books;
-- SELECT Book_ID, Title FROM Books;
SELECT * FROM Books WHERE Publication_Year = 1980;
SELECT * FROM Books WHERE Genre = 'Children';
SELECT * FROM Books WHERE Genre = 'Children' and Publication_Year = 1994;