Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

this code keeps giving error how do i fix it ? this part 3 by the way ** 09 Limit to 1000 rows Auton the

this code keeps giving error how do i fix it ?
this part 3 by the way image text in transcribed
image text in transcribed
image text in transcribed
** 09 Limit to 1000 rows Auton the to: curren autom Fiter objects 115 Tables Views stored Procedures Functions 9 10. 110 12 13 UPDATE UTIVER SET STATUSEON LEAVE FROM DRIVER D JOIN TRIP T ON D.LNUM=T.LNUM GROUP BY D.LNUM HAVING COUNT (T.LNUM)> 50 14 15 16 - 17 DELETE FROM TRIP WHERE TNUM: DELETE FROM TRIPLEG WHERE TNUM811 Action Output Time Action Mesa Duration: VUL Action: UPDATE OTIVER SET STATUS 'ON LEAVE FROM DRIVER DJOIN TRIPT ON D.LNUM-TALNUN GROUP BY DUNUM HAVING COUNT(TLNUM) OM50' at line 2 Response: Error Code: 1064. You have an error in your SQL syntax; check the wave an error in your se manual that corresponds to your MySQL server version for the right syntax to 0.00023 use near 'FROM DRIVER DJOIN TRIP TOND.LNUM-T.LNUM GROUP BY D.LNUMM) allineate Windows HAVING COUNT(ULNUM)' at line 2 Duration: 0.00023 sec Query interrupted S LISTED BELOW CREATE TABLE STAFF ENUM DECIMAL (12) NOT NULL / Statt employee number FNAME VARCHAR(50) NOT NULL First se LNAME VARCHAR(50) NOT NULLA / Last name DATE Date of birth CONSTRAINT STAFF_PKEY PRIMARY KEY (ENUN) : CREATE TABLE DRIVER ENUM DECIMAL (12) NOT NULL Statt employee number LNUM DECIMAL (8) NOT NULL. / Driving license number STATUS VARCHAR (10) NOT NULL, Driver status CONSTRAINT DRIVER_PKEY PRIMARY KEY (ENUN). CONSTRAINT DRIVER_UNIQUE UNIQUE (LNUM). CONSTRAINT DRIVER FREY FOREIGN KEY CENTIM) REFERENCES STAFF (2020). 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 (2) NOT NULL Weight STATUS VARCHAR(10) NOT NULL Present states CONSTRAINT TRUCK PREY PRIMARY KEY (REGNUM), CONSTRAINT TRUCK_STATUS CHECK STATUS IN 'AVAILABLE. USED, MAINTAINED), CONSTRAINT TRUCK WEIGHT CHECK WEIGHT > 0.0 AND WEIGHT 0.0 AND CAPACITY

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Databases And Python Programming MySQL MongoDB OOP And Tkinter

Authors: R. PANNEERSELVAM

1st Edition

9357011331, 978-9357011334

More Books

Students also viewed these Databases questions

Question

How flying airoplane?

Answered: 1 week ago