Consider the insurance database given below , where the primary keys
are underlined. Construct the following SQL queries for this relational
database.
a. Find the total number of people who owned cars that were involved
in accidents in 2009.
b. Add a new accident to the database; assume any values for required
attributes.
c. Delete the Mazda belonging to “John Smith”.
person (driver id, name, address)
car (license, model, year)
accident (report number, date, location)
owns (driver id, license)
participated (report number, license, driver id, damage amount)