Consider the following schema: vehicle(vid, manufacturer, mo…

Consider the following schema: vehicle(vid, manufacturer, model)  //vehicle ID, manufacturer, and model technician(tid, name, dateHired)    //technician ID, name, and date hiredrepair(tid, vid, amount)                   //technician ID, vehicle ID, and repair amount  Note: Underlined attributes represent primary keys. Write an SQL query to list all vehicles, including those that have never been repaired (Use the left outer join).