CREATE TABLE BooksAuthors (ISBN CHAR(13), Author_Id CHAR(4), Seq_No INT)
INSERT INTO BooksAuthors VALUES ('0-07-882198-3', 'KARP', 1)
INSERT INTO BooksAuthors VALUES ('0-78970541-9', 'EVAN', 1)
INSERT INTO BooksAuthors VALUES ('0-12623540-6', 'SCHE', 1)
INSERT INTO BooksAuthors VALUES ('1-56-884454-9', 'TAYL', 1)
INSERT INTO BooksAuthors VALUES ('1-56884645-2', 'SMIT', 1)
INSERT INTO BooksAuthors VALUES ('1-56884645-2', 'BEBA', 2)
INSERT INTO BooksAuthors VALUES ('1-56884703-3', 'TITT', 1)
INSERT INTO BooksAuthors VALUES ('1-56884703-3', 'GAIT', 2)
INSERT INTO BooksAuthors VALUES ('1-56884703-3', 'HASS', 3)
INSERT INTO BooksAuthors VALUES ('1-56884703-3', 'ERWI', 4)
INSERT INTO BooksAuthors VALUES ('1-56276390-3', 'ARPA', 1)
INSERT INTO BooksAuthors VALUES ('1-57-169050-7', 'KERV', 1)
INSERT INTO BooksAuthors VALUES ('1-57-169050-7', 'FOUS', 2)
INSERT INTO BooksAuthors VALUES ('1-57-169050-7', 'ZAKO', 3)
INSERT INTO BooksAuthors VALUES ('1-57169066-2', 'CEAR', 1)
INSERT INTO BooksAuthors VALUES ('1-56-276352-0', 'ARON', 1)
INSERT INTO BooksAuthors VALUES ('0-78970812-4', 'STAU', 1)
INSERT INTO BooksAuthors VALUES ('0-13-232331-1', 'NEOU', 1)
INSERT INTO BooksAuthors VALUES ('0-13-232331-1', 'RECK', 1)
INSERT INTO BooksAuthors VALUES ('1-56-884647-9', 'TITT', 1)
INSERT INTO BooksAuthors VALUES ('1-56-884647-9', 'JAME', 2)
INSERT INTO BooksAuthors VALUES ('1-56884990-7', 'RAY1', 1)
INSERT INTO BooksAuthors VALUES ('1-56884990-7', 'RAY2', 2)
INSERT INTO BooksAuthors VALUES ('0-13-242488-6', 'MOR2', 1)
INSERT INTO BooksAuthors VALUES ('0-02188448-8', 'CAST', 1)
INSERT INTO BooksAuthors VALUES ('1-55615948-X', 'MOR1', 1)
INSERT INTO BooksAuthors VALUES ('0-53451626-2', 'POWE', 1)
INSERT INTO BooksAuthors VALUES ('1-56-604288-7', 'HARR', 1)
INSERT INTO BooksAuthors VALUES ('1-56-604288-7', 'KIDD', 2)
INSERT INTO BooksAuthors VALUES ('0-07-912100-4', 'CHU1', 1)
INSERT INTO BooksAuthors VALUES ('0-07-912100-4', 'CHIN', 2)
INSERT INTO BooksAuthors VALUES ('0-78970867-1', 'MUL1', 1)
INSERT INTO BooksAuthors VALUES ('0-47-114242-5', 'GRAH', 1)
INSERT INTO BooksAuthors VALUES ('0-07-970411-0', 'SCHA', 1)
INSERT INTO BooksAuthors VALUES ('1-57-169018-2', 'FOX1', 1)
INSERT INTO BooksAuthors VALUES ('1-57-169018-2', 'DOWN', 2)
INSERT INTO BooksAuthors VALUES ('1-56-592175-5', 'MUSC', 1)
INSERT INTO BooksAuthors VALUES ('1-56-592175-5', 'KENN', 2)
INSERT INTO BooksAuthors VALUES ('1-56205617-4', 'READ', 1)
INSERT INTO BooksAuthors VALUES ('1-56205617-4', 'WARN', 2)
INSERT INTO BooksAuthors VALUES ('1-56-88499-66', 'TITT', 1)
INSERT INTO BooksAuthors VALUES ('0-18-83577578', 'LEJE', 1)
INSERT INTO BooksAuthors VALUES ('0-18-83577578', 'DUNT', 2)
INSERT INTO BooksAuthors VALUES ('1-57-521005-3', 'LEMA', 1)
INSERT INTO BooksAuthors VALUES ('1-57-521064-9', 'LEMA', 1)
INSERT INTO BooksAuthors VALUES ('1-57-521096-7', 'LEMA', 1)
INSERT INTO BooksAuthors VALUES ('0-13460296-X', 'SOSI', 1)
INSERT INTO BooksAuthors VALUES ('0-13460296-X', 'PARK', 2)
INSERT INTO BooksAuthors VALUES ('1-88790205-8', 'GROV', 1)
INSERT INTO BooksAuthors VALUES ('0-78-970622-9', 'RAND', 1)
INSERT INTO BooksAuthors VALUES ('0-78-970622-9', 'JUNG', 1)
INSERT INTO BooksAuthors VALUES ('0-78-970622-9', 'KNAU', 1)
INSERT INTO BooksAuthors VALUES ('0-78-970622-9', 'SAVO', 1)
INSERT INTO BooksAuthors VALUES ('1-88-357787-X', 'BROW', 2)
INSERT INTO BooksAuthors VALUES ('1-88-357787-X', 'JUNG', 3)
INSERT INTO BooksAuthors VALUES ('1-88-357787-X', 'BRAN', 4)
INSERT INTO BooksAuthors VALUES ('1-88-357787-X', 'MEGA', 1)
INSERT INTO BooksAuthors VALUES ('1-88-357787-X', 'SAVO', 1)
INSERT INTO BooksAuthors VALUES ('0-07-912273-6', 'KRCM', 1)
INSERT INTO BooksAuthors VALUES ('0-78-970758-6', 'MUL2', 1)
SELECT * FROM BooksAuthors
