In SQL, running on an Oracle database, write a query to complete the following task:

1.) Find the total damage amount from all accidents in which the cars manufactured by BMW were involved.

Notes: the answer should include the damage produced to other cars involved in the same accidents with the BMW cars; the amount must be reported for all accidents together, not per accident.

-- if tables already exist, drop them

drop table Person;

drop table Owns;

drop table Car;

drop table Participated;

drop table Accident;

--create tables and insert tuples for Problem 1

create table Person

(Driver_id numeric(2),

Name varchar2(20),

Address varchar2(15),

primary key (Driver_id));

create table Car

(License varchar2(7),

Model varchar2(8),

Year numeric(5),

primary key (License));

create table Owns

(Driver_id numeric(2),

License varchar2(7),

primary key (License));

create table Accident

(Report_nr varchar2(4),

Accident_date date,

Location varchar2(20),

primary key (Report_nr));

create table Participated

(Report_nr varchar2(4),

License varchar2(7),

Driver_id numeric(2),

Damage_amt numeric(10),

primary key (Report_nr, License));

insert into Person values (0,'Jenson Button','University St');

insert into Person values (1,'Rubens Barrichello','1st Ave');

insert into Person values (2,'Sebastian Vettel','1st Ave');

insert into Person values (3,'Mark Webber','1st Ave');

insert into Person values (4,'Lewis Hamilton','1st Ave');

insert into Person values (5,'Felipe Massa','University St');

insert into Car values ('SZM813','Honda',2009);

insert into Car values ('SZM814','Toyota',2009);

insert into Car values ('SZM815','BMW',2009);

insert into Car values ('SZM816','Honda',2009);

insert into Car values ('SZM817','Honda',2008);

insert into Car values ('SZM818','BMW',2008);

insert into Car values ('SZM819','BMW',2008);

insert into Car values ('SZM820','Toyota',2008);

insert into Accident values ('R01','13-APR-2008','Monza');

insert into Accident values ('R02','22-JUL-2008','Indianapolis');

insert into Accident values ('R03','22-JUL-2008','Indianapolis');

insert into Accident values ('R04','22-JUL-2008','New York');

insert into Accident values ('R05','27-JUL-2008','New York');

insert into Accident values ('R06','27-JAN-2009','Highland Heights');

insert into Accident values ('R07','15-FEB-2009','Highland Heights');

insert into Owns values (0,'SZM813');

insert into Owns values (1,'SZM814');

insert into Owns values (2,'SZM815');

insert into Owns values (3,'SZM816');

insert into Owns values (4,'SZM817');

insert into Owns values (5,'SZM818');

insert into Owns values (0,'SZM819');

insert into Owns values (4,'SZM820');

insert into Participated values ('R01','SZM813',0,4000);

insert into Participated values ('R02','SZM814',1,6000);

insert into Participated values ('R03','SZM815',4,6000);

insert into Participated values ('R04','SZM814',1,1000);

insert into Participated values ('R05','SZM817',4,6000);

insert into Participated values ('R06','SZM818',5,5000);

insert into Participated values ('R07','SZM819',0,5000);

insert into Participated values ('R04','SZM817',4,3000);

insert into Participated values ('R05','SZM813',0,4000);

insert into Participated values ('R06','SZM814',3,2000);

insert into Participated values ('R07','SZM814',1,1000);

insert into Participated values ('R07','SZM820',4,6000);

insert into Participated values ('R07','SZM813',3,4000);

COMMIT;

Table 1: Person Table 2: Car License SZM813 SZM814 SZM815 SZM816 SZM817 SZM818 SZM819 SZM820 Name Address Y ear 2009 2009 2009 2009 2008 2008 2008 2008 0 enson Button Rubens Barrichello 1st Ave Sebastian Vettel Mark Webber Lewis Hamilton Felipe Massa niversity St Toyota BMW University St BMW Toyota Table 3: Owns Table 4: Accident icense SZM813 SZM814 SZM815 SZM816 SZM817 SZM818 SZM819 SZM820 0 Report nrAccident date Location 04-13-2008 07-22-2008 07-22-2008 07-22-2008 07-27-2008 01-27-2009 02-15-2009 Monza Indianapolis Indianapolis R02 RO3 R04 R05 RO6 RO7 New York 0 Highland Heights Table 5: Participated Report nrLicense Driverid Damage amt SZM813 SZM814 SZM815 4 SZM814 SZM817 SZM8185 SZM819 0 SZM817 4 0 4000 6000 6000 1000 6000 5000 5000 3000 4000 2000 R02 R03 R04 Important: in the table Participated, the Driver id column records the id of the erson who drove the car involved in an accident-this person could be different rom or the same as the person owning R07 R04 R05 R06 SZM813 0 e cai. SZM814 SZM814 SZM820 SZM8133 R07 R07 6000