#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use The image displays an SQL query execution attempt in a database management interface, which results in an error. Below is the transcription and explanation for educational purposes:### SQL Query Attempt:1. **SQL Code:** ```sql CREATE OR REPLACE TRIGGER TRG_LINE_TOTAL BEFORE INSERT ON LINE FOR EACH ROW BEGIN :NEW.LINE_TOTAL := :NEW.LINE_UNITS * :NEW.LINE_PRICE; END; / ```### Explanation:- **Trigger Definition:** - A trigger named `TRG_LINE_TOTAL` is created or replaced. - It is set to execute before inserting a row into the `LINE` table. - The purpose is to calculate the `LINE_TOTAL` value by multiplying `LINE_UNITS` and `LINE_PRICE` for each row.### Error Details:- **Error Message:** ``` MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ':NEW.LINE_TOTAL := :NEW.LINE_UNITS * :NEW.LINE_PRICE' at line 5 ```#### Explanation of the Error:- **Error Code:** #1064- **Description:** There is a syntax error in the SQL query, specifically in the line attempting to set `:NEW.LINE_TOTAL`.- **Cause:** This syntax is incorrect for MySQL/MariaDB, where the use of `:NEW` for referencing new column values in a trigger is invalid. The `:=` assignment operator and colon-prefixed syntax are often used in PL/SQL, not in MySQL/MariaDB.### Suggested Correction:In MySQL, a similar operation should be written differently, typically using a `SET` statement. For example:```sqlCREATE TRIGGER TRG_LINE_TOTALBEFORE INSERT ON LINEFOR EACH ROWBEGIN SET NEW.LINE_TOTAL = NEW.LINE_UNITS * NEW.LINE_PRICE;END;```### Educational Note:- **Triggers:** Useful for automatically applying business rules or updating fields during insert, update, or delete operations on tables.- **Syntax Compatibility:** Always ensure compatibility with the SQL dialect used by the specific database system. MySQL and MariaDB have different syntax rules compared to Oracle's PL/SQL.

Actually, database is a used to stores the data.CREATE TABLE L_Customers ( Customer_No INT(5) NOT NULL, Name VARCHAR(20) NOT NULL, Address VARCHAR(20), City VARCHAR(20), State VARCHAR(2), Zip VARCHAR(5), Telephone VARCHAR(14) NOT NULL, CONSTRAINT L_Customers_PK PRIMARY KEY (Customer_No)); CREATE TABLE L_Orders ( Order_No INT(5) NOT NULL, Customer_No INT(5), Item_No INT(5), Qty INT(5), CONSTRAINT L_Orders_PK PRIMARY KEY (Order_No), CONSTRAINT L_Orders_FK1 FOREIGN KEY (Customer_No) REFERENCES L_Customers(Customer_No)););After inserting data two tables are: L_Customers: L_orders: