Consider the insurance database, where the primary keys
are underlined. Construct the following SQL queries for this relational
database.
a. Find the number of accidents in which the cars belonging to “John
Smith” were involved.
b. Update the damage amount for the car with the license number
“AABB2000” in the accident with report number “AR2197” to $3000.
here is the database
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)
