Hello this is for (SQL MINDTAP CENGAGE):

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.

Create an INDEX to search for driver information.

Here is my code:

CREATE INDEX NameSearch

ON ACTIVE_DRIVERS (DRIVER_FIRST_NAME, DRIVER_LAST_NAME, DRIVER_DRIVING_LICENSE_ID);

Here is my error:

ERROR 1146 (42S02) at line 1: Table 'InstantRide.ACTIVE_DRIVERS' doesn't exist