Need assistance on a MySQL question:  Create a trigger named trg_line_prod that automatically updates the quantity on hand for each product sold after a new LINE row is added. My Query:  CREATE OR REPLACE TRIGGER trg_line_prod AFTER INSERT ON LINE FOR EACH ROW BEGIN UPDATE PRODUCT SET P_QOH= P_QOH - :NEW.LINE_UNITS WHERE PRODUCT.P_CODE = :NEW.P_CODE; END; Error Received:  ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TRIGGER trg_line_prod AFTER INSERT ON LINE FOR EACH ROW BEGIN UPDATE ' at line 1

Task 2: StayWell is an active business and already has some data collected over e-mails and phone conversations. You need to insert the following data to the OWNER and PROPERTY tables: Add the provided information to the OWNER table. Add the provided information to the PROPERTY table.

Q1Create a view named v_Title_Unavailable.The view should show the movie titles and media_id of the media not returned yet. The view should not allow any DML operationsQ2Create a SYNONYM for v_Title_Unavailable named vTU.Q3Write SQL to query the view using the synonym.

PLZ HELP WITH THE FOLLOWING: make the following work select MOVIE_NAME, MOVIE_YEAR from MOVIE where  MOVIE_COST > (select a.MOVIE_COST from MOVIE a, PRICE b where a.PRICE_CODE = b.PRICE_CODE and b.PRICE_DESC ="weekly Special");   CREATE TABLE MEMBERSHIP (   MEM_NUM CHAR(3) CONSTRAINT MEMBER_MEMNUM_PK PRIMARY KEY,   MEM_FNAME VARCHAR(30) NOT NULL,   MEM_LNAME VARCHAR(30) NOT NULL,   MEM_STREET VARCHAR(30),   MEM_CITY VARCHAR(10),   MEM_STATE CHAR(2),   MEM_ZIP CHAR(5),   MEM_BALANCE NUMBER(2) );   CREATE TABLE RENTAL (   RENT_NUM CHAR(4) CONSTRAINT RENTAL_RENTNUM_PK PRIMARY KEY,   RENT_DATE DATE,   MEM_NUM CHAR(3),   CONSTRAINT RENTAL_MEMNUM_FK FOREIGN KEY (MEM_NUM) REFERENCES MEMBERSHIP );   CREATE TABLE PRICE (   PRICE_CODE CHAR(1) CONSTRAINT PRICE_PRICECODE_PK PRIMARY KEY,   PRICE_DESC VARCHAR(20),   PRICE_RENTFEE NUMBER (3, 1),   PRICE_DAILYATFEE NUMBER(3, 1) );   CREATE TABLE MOVIE (   MOVIE_NUM CHAR(4) CONSTRAINT MOVIE_MOVIENUM_PK PRIMARY KEY,   MOVIE_NAME VARCHAR(30) NOT NULL,…

Task 4: The Driver Relationship team wants to have quick search options for the active drivers. The team specifically mentioned that they are using first name, last name and driving license ID to search the drivers. Create an index called NameSearch on the ACTIVE_DRIVERS table created in task 3.   ASNWER IN MYSQL PLEASE

In MySQL please: The Question: Create a trigger named trg_char_hours that automatically updates the AIRCRAFT table when a new CHARTER row is added. Use the CHARTER table’s CHAR_HOURS_FLOWN to update the AIRCRAFT table’s AC_TTAF, AC_TTEL, and AC_TTER values. (Hint: use temp values, as the INSERT event does not accept the OLD keyword.)

Without using the MAJOR_CUSTOMER VIEW, retrieve the customer ID, first name, and last name for every customer whose credit limit is $500 or less.

Insert at least three rows into your EMPLOYEE_xx table. Use the next value of the sequence you created , EMPL_SEQUENCE_xx  as the value for the employee ID for every row inserted.   You may choose values for the other columns   Test your constraint on the rate column by trying to update a row in the EMPLOYEE_xx table with the value of 6 used for the Pay Rate (you choose the row).   Drop your EMPLOYEE_xx table and make sure it HAS been purged from the recyclebin

#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 OR_CASE table has one bro per surgical case. The OR_LOG table has one row per surgical log. It's LOG_ID column identifies each log.  If a case has an associated log, OR_CASE.LOG_ID will store the logs ID. Otherwise, it will be null. A query uses the following join: FROM OR_CASE INNER JOIN OR_LOG ON OR_CASE.LOG_ID=OR_LOG.LOG_ID which of the following would be the results? A. A log with no associated case.B. A log with an associated case. C. A case with no associated log.D. Rows with no case or log.