Question: In SQL, running on an Oracle database, write a query for each problem that solves the task. 1) Find the total damage amount from all
In SQL, running on an Oracle database, write a query for each problem that solves the task.
1) Find the total damage amount from all accidents in which the cars manufactured by BMW were involved -- note: the answer should include the damage produced to other cars involved in the same accidents with the BMW cars.
2) Find the average damage amount from all accidents in which the cars owned by Rubens Barrichello were not involved.
Note: Each query should produce the results shown below respectively. Please ensure your code produces similar results.
Query 1 Result:
TOT_DAM 29000
Query 2 Result:
AVG_DAM 4500

Table 1: Person Driver id Name Jenson Button Rubens Barrichello1st Ave Sebastin Vettel Mark Webber Lewis Hamilton Felipe Massa Unirersity St 8 Unirersity St Tabe 3: Owns Driver id License Report nAccident dateLocation 04-13-2008 Highland Heights Highland Heights Report nr License Driver id Damage amt
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
