Home Vehicle year that may contain the vehicle information provided by the witness

# Vehicle year that may contain the vehicle information provided by the witness

user1213
1#
user1213 Published in April 20, 2018, 6:02 pm
 For my CIS class, I have SQL project, I'm still very new to SQL and trying to learn it. Any help would be greatly appreciated. Query: The collected evidence shows that the vehicle's color is white, the make is BMW, and some letters on the plate were remembered: there is three letter "C"s on the plate. Required: Write a query to show all driver names and license_plate_number/vehicle_make/ vehicle year that may contain the vehicle information provided by the witness. Add attributes if necessary to complete the assignment. I did the first part of this problem: select driver_name as "Driver Name", license_plate_number as "License Plate Number", vehicle_make as "Make", make_year as "Year" from driver, license where driver.driver_id = license.driver_id  But for the second part I'm getting an empty return, I do not know what I'm doing wrong. This is what I tried: select driver_name, license_plate_number, vehicle_make, make_year from driver, license where driver.driver_id = license.driver_id and license_plate_number like 'C%%CC%%' and vehicle_make = "BMW" and color = "white" 
 You need to login account before you can post.
Processed in 0.304907 second(s) , Gzip On .