Question: trip_start_actual and trip_end_actual format. USING SQL: COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT 1 TRIP_ID NUMBER (6,0) NO (null) 2 TRIP_START DATE No (null) 3 TRIP_END DATE No

trip_start_actual and trip_end_actual format.

USING SQL:

COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT 1 TRIP_ID NUMBER (6,0) NO (null) 2 TRIP_START DATE No (null) 3 TRIP_END DATE No (null) 4 TRIP_START_ACTUAL DATE Yes (null) 5 TRIP_END_ACTUAL DATE Yes (null) 6 TRIP_START_KM NUMBER (6,0) Yes (null) 7 TRIP_END_KM NUMBER (6,0) Yes (null) 8 TRIP_PASSENGERS NUMBER (2,0) (null) 9 VEH_VIN CHAR(17 BYTE) NO (null) 10 LOCATION_ID_FROM NUMBER (6,0) (null) 11 LOCATION_ID_TO NUMBER (6,0) No (null) 12 OFF_OLYMPIC_ID CHAR (8 BYTE) No (null) 13 DRIVER_ID NUMBER (4,0) No (null) COLUMN_ID COMMENTS 1 Unique identifier for a trip 2 Date and time the trip is booked to start 3 Date and time the trip is booked to end 4 Date and time the booked trip actually starts 5 Date and time the booked trip actually ends 6 The odometer reading at the start of the trip 7 The odometer reading at the end of the trip 8 The odometer reading at the end of the trip 9 Vehicle identification number 10 Location identification number of pickup location of the trip 11 Location identification number of drop off location of the trip 12 Official olympic id 13 Unique identifier for a driver No No 08/Feb/2022 08:15:45', 'dd/mon/yyyy hh24:mi:38'), 08/Feb/2022 09:29:12', 'dd/mon/yyyy hh24:mi:55'), OLS wishes to record the actual trip duration for each completed trip (the duration of each completed trip must be rounded to whole minutes). Modify the database structure and update the appropriate trip data to implement this requirement
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
