how to solve this there must be another way ? without disabling safe mode.

this is part 3 btw

13 HAVING COUNT(T.LNUM)>50; 14 15. 16 UPDATE DRIVER SET STATUS ON LEAVE! WHERE LNUM IN(SELECT LNUM FROM TRIP GROUP BY LNUM HAVING COUNT(*)>100); 17 Action Output # Time 1 01:33 Action Message ou are using safe update Action: UPDATE DRIVER SET STATUS='ON LEAVE' WHERE LNUM IN(SELECT mode, toggle the option in Pr LNUM FROM TRIP GROUP BY LNUM HAVING COUNT(*)>100) Response: Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect. Duration: 0.00053 sec Write the data manipulation statements of SQL that modify the contents of a database listed on page 2 of this lab task in the ways described below. Note that you are not allowed to modify and/or to drop any consistency constraints. Also note, that to implement some of the modifications listed below, you may need more than one data manipulation statement (1) (2) A new trip has been completed today. The trip was from Sydney to Newcastle. The trip has been performed by the driver with the licence number 104777 (column LNUM in a relational table TRIP) who used the truck with registration number AOR84H. Insert the appropriate information into the sample database assuming the next trip number is 10245. (2 marks) Delete the information from the database about trip number 61. Remember, that the foreign keys in all CREATE TABLE statements have no ON DELETE CASCADE clause. (2 marks) Change the status of all the drivers who have performed more than 100 trips to on ON LEAVE. (2 marks) (3) LISTED BELOW NULL, CREATE TABLE STAFF ENUM DECIMAL (12) NOT NULL / Staft employee number FNAME VARCHAR(50) NOT NULL, 1. First se LNAME VARCHAR(50) NOT NULLA / Last name DOR DATE Date of birth CONSTRAINT STAFF_PKEY PRIMARY KEY (EUR): CREATE TABLE DRIVER ENUM DECIMAL (12) NOT NULL, Statt ployee number LNUM DECIMAL (8) NOT NULL. / Driving license number STATUS VARCHAR(10) NOT NULL Driver status CONSTRAINT DRIVER_PKEY PRIMARY KEY (ENUM). CONSTRAINT DRIVER_UNIQUE UNIQUE (LNUM). CONSTRAINT DRIVER FREY FOREIGN KEY CENTIM) REFERENCES STAFF LEBUH). CONSTRAINT DRIVER STATUS CHECK STATUS IN "AVAILABLE IN SERVICE", "ON LEAVE"> CREATE TABLE TRUCK REGNUM VARCHAR(10) NOT NULL, Registration number CAPACITY DECIMAL (7) NOT NULL Capacity WEIGHT DECIMAL (7) NOT NULL Weight STATUS VARCHAR(10) NOT NULL Present states CONSTRAINT TRUCK PKEY PRIMARY KEY (REGNUM), CONSTRAINT TRICK_STATUS CHECK STATUS IN "AVAILABLE. USED, MAINTAINED">). CONSTRAINT TRUCK WEIGHT CHECK (WEIGHT > 0.0 AND WEIGHT 0.0 AND CAPACITY