SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 338 Weeks Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 15 Nov 2017 My Price 10.00

construct the SQL statement that answers the question.

Need some help with questions 10, 12, 14, and 15. I only need the SQL queries to answer the questions. Any help would be greatly appreciated.

SQL Commands 

After each question, construct the SQL statement that answers the question.

 

1.      List all the information about the properties.

 

 

2.      List information about damages including the street address.

 

 

3.      What were the different sources of damage (no duplicate reporting)?

 

 

4.      What was the total amount of damages assessed?

 

 

5.      What were the total damages for each property?

 

 

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

 

 

7.      How many damages were reported?

 

 

8.      List the information about the properties whose zip codes start with 301.

 

 

9.      List the properties in Woodstock that were damaged.

 

 

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

 

 

11.  List the report information for inspectors Jones, Smith, White [use the IN keyword].

 

 

12.  Which inspector(s) reported total damage amounts >$30,000 for all properties they inspected?

 

 

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

 

 

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

 

 

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

 

Data Tables for IS3280 Test 2-Part 2{This data is fictitious.}

PROPERTY

test2property.jpg

DAMAGE

test2damage.jpg

DAMAGEREPORT

test2damagereport.jpg

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 15 Nov 2017 01:11 PM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)