Question: please solve this question database lab thanks ll touch 17:16 50% CSC1335L_Test2_A_V... a COBS! Diab - Test 2 Fall 2020 2021 Section- Answer all the
ll touch 17:16 50% CSC1335L_Test2_A_V... a COBS! Diab - Test 2 Fall 2020 2021 Section- Answer all the following questions by writing the appropriate SQL queries in a word document with your name and student number, then hund the word document once done. Good luck Owner Name Sam Smith 2 Saraiver von Phone 0101190 OLC 2000 222 L-1970 Car Number Owner_id 1 2 BMW alep 1 Toyota Com 2030 10000 2036 15000 2007 20000 Based on the above tables, write the SQL statements for each of the following operation: 1. Create the tables Owner and Car as shown above 2. Insert the data shown above for each table. 3. Update the Brand to "Honda" for the car with Number - 1. 4. Delete the Owner with name start with letter 'E'. 5. Display all cars' Brand and Ycar which cost between 10000 and 25000 6. Display all distinct owners whose Name contain letter or starts with letter 7. Display all cars owned by an owner with phone --222 8. Display all ownets" name with their corresponding cars" Brand and Year which Cest> 15000
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
