CREATE TABLE tblBook (
    ISBN int PRIMARY KEY,
    Title varchar(255) NOT NULL,
    Author varchar(255),
    PublicationYr varchar(255),
    Price int
);
 
INSERT INTO tblBook (ISBN, BookTitle, Author, PublicationYr, Price)
VALUES 
    (1001, 'Anna Karenina', 'Leo Tolstoy', '2008-03-25', 3500),
    (1002, 'To Kill a Mockingbird', 'Harper Lee', '2010-07-30', 2750),
    (1003, 'The Great Gatsby', 'F. Scott Fitzgerald', NULL, 2000),
    (1004, 'One Hundred Years of Solitude', 'Gabriel Garcia Marquez', '2013-02-23', NULL),
    (1005, 'A Passage to India', 'E.M. Forster', '2009-05-09', 1750);
 
 
SELECT * FROM tblBook;

Q1JFQVRFIFRBQkxFIHRibEJvb2sgKAogICAgSVNCTiBpbnQgUFJJTUFSWSBLRVksCiAgICBUaXRsZSB2YXJjaGFyKDI1NSkgTk9UIE5VTEwsCiAgICBBdXRob3IgdmFyY2hhcigyNTUpLAogICAgUHVibGljYXRpb25ZciB2YXJjaGFyKDI1NSksCiAgICBQcmljZSBpbnQKKTsKCklOU0VSVCBJTlRPIHRibEJvb2sgKElTQk4sIEJvb2tUaXRsZSwgQXV0aG9yLCBQdWJsaWNhdGlvbllyLCBQcmljZSkKVkFMVUVTIAogICAgKDEwMDEsICdBbm5hIEthcmVuaW5hJywgJ0xlbyBUb2xzdG95JywgJzIwMDgtMDMtMjUnLCAzNTAwKSwKICAgICgxMDAyLCAnVG8gS2lsbCBhIE1vY2tpbmdiaXJkJywgJ0hhcnBlciBMZWUnLCAnMjAxMC0wNy0zMCcsIDI3NTApLAogICAgKDEwMDMsICdUaGUgR3JlYXQgR2F0c2J5JywgJ0YuIFNjb3R0IEZpdHpnZXJhbGQnLCBOVUxMLCAyMDAwKSwKICAgICgxMDA0LCAnT25lIEh1bmRyZWQgWWVhcnMgb2YgU29saXR1ZGUnLCAnR2FicmllbCBHYXJjaWEgTWFycXVleicsICcyMDEzLTAyLTIzJywgTlVMTCksCiAgICAoMTAwNSwgJ0EgUGFzc2FnZSB0byBJbmRpYScsICdFLk0uIEZvcnN0ZXInLCAnMjAwOS0wNS0wOScsIDE3NTApOwogICAgCiAgICAKU0VMRUNUICogRlJPTSB0YmxCb29rOw==