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

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:

  1. 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.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.304907 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO