Write a SQL statement that answers the question: What were the total damages for

Question

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

Explanation / Answer

Ans 1

Select LotNo from Property Join on DamageReport.DamageAmt=Property.LotNo where Sum(DamageAmt) order by LotNo;

Ans 2

Select LotNo (001,002,003) from Property Join on Damage Where Did (001,002,003);

Ans 3

Select StreetAddress from Property Join On Property.StreetAddress=Damage.Description;

Ans 4

Select StreetAddress from Property Join On Damage.Location=’FirstFloor’;

Ans 5

Select LotNo from Property.StreetAddress Join On Damage.Description;

Ans 6

Create VIEW view AS Select StreetAddress , City where Damage.Description= wet carpet OR buckled floor;

Ans 7

Select Did, Location from Damage Order by Did, Location ASC;

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.