Question

4. Result: Obtain a list of every vehicle passing camera 10 on 25th Feb 2007. whn reg name Show the time, the registration and the name of the keeper if available. SELECT iwhn, i.reg, k.name FROM image i, keeper k, vehicle v WHERE i.reg-v.id AND k.id . v keeper AND ǐwhn·2007-02-25 Sebmit SQL Restore default

How do i fix my above code

Answer 1

QUERY:

SELECT vehicle.id, image.whn, image.reg, vehicle.keeper FROM vehicle, image, permit WHERE image.camera = 10 AND image.whn = 2007-02-25 AND image.reg IN (SELECT reg FROM permit);

Explanation:

Here we need to select the vehicle captured by camera 10. So image.camera = 10 condition is included.

Also, reg number should be in the permit of the vehicle.