Examlex

Solved

VEHICLE
Observe the Table VEHICLE That Contains the Following Four

question 19

Essay

VEHICLE
Observe the table VEHICLE that contains the following four records:
VEHICLE
 Vehiclell  Type  Make  OwnerID  OwnerName 111 Car  Ford O1 Pam 222 Car  Ford O2 Pat 333 Truck  Honda O3 Pam 444 Car  Honda  O1  Pam \begin{array} { l l l c l } \text { Vehiclell } & \text { Type } & \text { Make } & \text { OwnerID } & \text { OwnerName } \\111 & \text { Car } & \text { Ford } & O 1 & \text { Pam } \\222 & \text { Car } & \text { Ford } & O2 & \text { Pat } \\333 & \text { Truck } & \text { Honda } & O 3 & \text { Pam } \\444 & \text { Car } & \text { Honda } & \text { O1 } & \text { Pam }\end{array}

This table will be used for the following questions citing table VEHICLE.
-Write the SQL query on the table VEHICLE that lists once the owner ID and owner name of each owner.


Definitions:

Related Questions