Write a SQL statement that answers the question:

What were the total damages for each property?

List the properties in Austelle that were damaged.

What properties were damaged (street address), what were the damages (description) and what was the amount of the damage?

Which property (by address) had damages from flooding on the first floor?

List all property street addresses and show the description of the damage for those that had damage.

Create a View to show street address and city of properties that had damage to their floors (wet carpet or buckled floor).

List the damages sorted by location (where the damage was located not where the property was located).

PROPERTY Austelle Austelle 1000 Chastain Road Kennesaw GA 1008 Chastain Road Kennesaw GA 1 29 Town Parkway Woodstock GA DAMAGE structural damage 7,800.00