FIX MY SQL CODE$<$ AND POST THE FULL UPDTED CODE PLEASE:

One of the errors is an invalid syntax on line $90,$ where it says incorrect syntax near the keyworrd 'COLUMN', the rest I cannot access or change.

$--$ Create Books Table $(1$NF: Initial Design$)$

CREATE TABLE Books $($

Book$\_$ID INT PRIMARY KEY,

Title VARCHAR$(255),$

Author VARCHAR$(255),$

Publisher VARCHAR$(255),$

ISBN VARCHAR$(20),$

Publication$\_$Year INT,

Price DECIMAL$(10,2),$

Genre VARCHAR$(100),$

Language VARCHAR$(50)$

$)$;

$--$ Create Authors Table $(1$NF: Initial Design$)$

CREATE TABLE Authors $($

Author$\_$ID INT PRIMARY KEY,

Author$\_$Name VARCHAR$(255),$

Birthdate DATE,

Nationality VARCHAR$(100),$

Book$\_$ID INT

$)$;

$--$ Create Publishers Table $(1$NF: Initial Design$)$

CREATE TABLE Publishers $($

Publisher$\_$ID INT PRIMARY KEY,

Publisher$\_$Name VARCHAR$(255),$

Publisher$\_$Location VARCHAR$(255),$

Year$\_$Founded INT,

Contact$\_$Email VARCHAR$(255)$

$)$;

$--$ Create Customers Table $(1$NF: Initial Design$)$

CREATE TABLE Customers $($

Customer$\_$ID INT PRIMARY KEY,

Customer$\_$Name VARCHAR$(255),$

Address VARCHAR$(255),$

Phone$\_$Number VARCHAR$(20),$

Order$\_$ID INT,

Book$\_$ID INT,

Title VARCHAR$(255),$

Order$\_$Date DATE,

Quantity INT,

Total$\_$Price DECIMAL$(10,2)$

$)$;

$--$ Create Orders Table $(1$NF: Initial Design$)$

CREATE TABLE Orders $($

Order$\_$ID INT PRIMARY KEY,

Customer$\_$ID INT,

Order$\_$Date DATE,

Total$\_$Price DECIMAL$(10,2)$

$)$;

$--$ Insert sample data into Books table

INSERT INTO Books $($Book$\_$ID$,$ Title, Author, Publisher, ISBN, Publication$\_$Year, Price, Genre, Language$)$

VALUES

$(1,$ 'Introduction to SQL$\text{'},$ 'John Doe', 'ABC Publications', $\text{'}978-0-12345\text{'},2020,29\mathrm{.}99,$ 'Textbook', 'English'$),$

$(2,$ 'Python Programming', 'Jane Smith', $\text{'}$XYZ Publishers', $\text{'}978-0-54321\text{'},2019,34\mathrm{.}99,$ 'Tutorial', 'English'$),$

$(3,$ 'Data Structures', 'Alice Johnson', 'ABC Publications', $\text{'}978-0-67890\text{'},2021,39\mathrm{.}99,$ 'Textbook', 'English'$)$;

$--$ Insert sample data into Authors table

INSERT INTO Authors $($Author$\_$ID$,$ Author$\_$Name, Birthdate, Nationality$)$

VALUES

$(1,$ 'John Doe', $\text{'}1980-05-15\text{'},$ 'American'$),$

$(2,$ 'Jane Smith', $\text{'}1975-09-20\text{'},$ 'British'$),$

$(3,$ 'Alice Johnson', $\text{'}1988-12-10\text{'},$ 'Canadian'$)$;

$--$ Insert sample data into Publishers table

INSERT INTO Publishers $($Publisher$\_$ID$,$ Publisher$\_$Name, Publisher$\_$Location, Year$\_$Founded, Contact$\_$Email$)$

VALUES

$(1,$ 'ABC Publications', 'New York', $1985,$ 'info@abcpub.com'$),$

$(2,\text{'}$XYZ Publishers', 'San Francisco', $1978,$ 'info@xyzpub.com'$)$;

$--$ Insert sample data into Customers table

INSERT INTO Customers $($Customer$\_$ID$,$ Customer$\_$Name, Address, Phone$\_$Number$)$

VALUES

$(1,$ 'John Smith', $\text{'}123$ Main St$.\text{'},\text{'}123-456-7890\text{'}),$

$(2,$ 'Jane Doe', $\text{'}456$ Elm St$.\text{'},\text{'}987-654-3210\text{'}),$

$(3,$ 'Alice Brown', $\text{'}789$ Oak St$.\text{'},\text{'}555-123-4567\text{'})$;

$--$ Insert sample data into Orders table

INSERT INTO Orders $($Order$\_$ID$,$ Customer$\_$ID$,$ Order$\_$Date, Total$\_$Price$)$

VALUES

$(1,1,\text{'}2023-01-15\text{'},69\mathrm{.}98),$

$(2,2,\text{'}2023-02-20\text{'},29\mathrm{.}99),$

$(3,3,\text{'}2023-03-10\text{'},119\mathrm{.}97)$;

$--1.$ Add Publisher$\_$ID column to Books table

ALTER TABLE Books

ADD COLUMN Publisher$\_$ID INT;

$--$ Update Publisher$\_$ID based on existing data in Publishers table

UPDATE Books

SET Publisher$\_$ID $=$ Publishers.Publisher$\_$ID

FROM Books

JOIN Publishers ON Books.Publisher $=$ Publishers.Publisher$\_$Name

WHERE Books.Book$\_$ID IN $(1,3)$;

$--2.$ Remove Author column from Books table

ALTER TABLE Books

DROP COLUMN Author;

$--3.$ Remove Book$\_$ID column from Authors table

ALTER TABLE Authors

DROP COLUMN Book$\_$ID;

$--$ Display the joined result of Books and Publishers tables

SELECT Books.Book$\_$ID$,$ Books.Title, Books.ISBN, Publishers.Publisher$\_$Name

FROM Books

INNER JOIN Publishers ON Books.Publisher$\_$ID $=$ Publishers.Publisher$\_$ID;

$--$ Display the joined result of Books and Authors tables

SELECT Books.Book$\_$ID$,$ Books.Title, Books.ISBN, Authors.Author$\_$Name

FROM Books

INNER JOIN Book$\_$Authors ON Books.Book$\_$ID $=$ Book$\_$Authors.Book$\_$ID

INNER JOIN Authors ON Book$\_$Authors.Author$\_$ID $=$ Authors.Author$\_$ID;

$--$ Display the joined result of Customers and Orders tables

SELECT Customers.Customer$\_$ID$,$ Customers.Customer$\_$Name, Orders.Order$\_$ID$,$ Orders.Order$\_$Date, Orders.Total$\_$Price

FROM Customers

INNER JOIN Orders ON Customers.Customer$\_$ID $=$ Orders.Customer$\_$ID;

$--$ Display the joined result of Customers, Orders, and Books tables

SELECT Customers.Customer$\_$ID$,$ Customers.Customer$\_$Name, Orders.Order$\_$ID$,$ Books.Title, Orders.Order$\_$Date, Orders.Quantity, Orders.Total$\_$Price

FROM Customers

INNER JOIN Orders ON Customers.Customer$\_$ID $=$ Orders.Customer$\_$ID

INNER JOIN Books ON Orders.Book$\_$ID $=$ Books.Book$\_$ID;