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

please solve this question
database lab
thanks  please solve this question database lab thanks ll touch 17:16 50%

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!