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

In SQL, running on an Oracle database, write a query for each

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

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!