Based on the table Zipcode_info in datamining database and the valid records ZipcodeType is 'STANDARD', LocationType='PRIMARY' and EstimatedPopulation cannot be null.

1. (6 points) Create a view vState(state, avg_wage, population, ct) in your database that includes 50 states and DC average wage. Avg_wage is the average wage (AvgWages) of the state, population is the total population of the state., and ct is the number of the zipcode for each state.

Answer:

2. (3 points) what is the Quartile 1, Quartile 2, Quartile 3 of the avg_wage.

Answer:

Q1: __________________ , Q2: __________________, Q3:__________________

3. (2 points) Please define and calcuate the upper limit and lower limit. You need to show how to calculate the values.

Upper limit:

Lower limit:

4. (4 points) Which states are the outliers based on the avg_wage?

| RecordNumber | Zipcode | ZipCodeType | City | State | LocationType | Latitude | Longitude | Xaxis | Yaxis | Zaxis | WorldRegion | Country | LocationText | Location | Decommisioned | TaxReturnsFiled | EstimatedPopulation | TotalWages | AvgWages | Notes |

+--------------+---------+-------------+------------------------------+-------+----------------+----------+-----------+----------------+-------+-------+-------------+---------+----------------------------------+------------------------------------------------------+--------------------+-----------------+---------------------+------------+----------+------------------------------------------------------------------------------------------------------------------------------+

| 1 | 00704 | STANDARD | PARC PARQUE | PR | NOT ACCEPTABLE | 17.96 | -66.22 | 0.38 | -0.87 | 0.3 | NA | US | Parc Parque, PR | NA-US-PR-PARC PARQUE | false | NULL | NULL | NULL | NULL | |

| 2 | 00704 | STANDARD | PASEO COSTA DEL SUR | PR | NOT ACCEPTABLE | 17.96 | -66.22 | 0.38 | -0.87 | 0.3 | NA | US | Paseo Costa Del Sur, PR | NA-US-PR-PASEO COSTA DEL SUR | false | NULL | NULL | NULL | NULL | |

| 3 | 00704 | STANDARD | SECT LANAUSSE | PR | NOT ACCEPTABLE | 17.96 | -66.22 | 0.38 | -0.87 | 0.3 | NA | US | Sect Lanausse, PR | NA-US-PR-SECT LANAUSSE | false | NULL | NULL | NULL | NULL | |

| 4 | 00704 | STANDARD | URB EUGENE RICE | PR | NOT ACCEPTABLE | 17.96 | -66.22 | 0.38 | -0.87 | 0.3 | NA | US | Urb Eugene Rice, PR | NA-US-PR-URB EUGENE RICE | false | NULL | NULL | NULL | NULL | |

| 5 | 00704 | STANDARD | URB GONZALEZ | PR | NOT ACCEPTABLE | 17.96 | -66.22 | 0.38 | -0.87 | 0.3 | NA | US | Urb Gonzalez, PR | NA-US-PR-URB GONZALEZ | false | NULL | NULL | NULL | NULL | |

| 6 | 00704 | STANDARD | URB LA FABRICA | PR | NOT ACCEPTABLE | 17.96 | -66.22 | 0.38 | -0.87 | 0.3 | NA | US | Urb La Fabrica, PR | NA-US-PR-URB LA FABRICA | false | NULL | NULL | NULL | NULL | |

| 7 | 00704 | STANDARD | URB MONTE SORIA 2 | PR | NOT ACCEPTABLE | 17.96 | -66.22 | 0.38 | -0.87 | 0.3 | NA | US | Urb Monte Soria 2, PR | NA-US-PR-URB MONTE SORIA 2 | false | NULL | NULL | NULL | NULL | |

| 8 | 00704 | STANDARD | VILLAS DEL COQUI | PR | NOT ACCEPTABLE | 17.96 | -66.22 | 0.38 | -0.87 | 0.3 | NA | US | Villas Del Coqui, PR | NA-US-PR-VILLAS DEL COQUI | false | NULL | NULL | NULL | NULL | |

| 9 | 00705 | STANDARD | AIBONITO | PR | PRIMARY | 18.14 | -66.26 | 0.38 | -0.86 | 0.31 | NA | US | Aibonito, PR | NA-US-PR-AIBONITO | false | NULL | NULL | NULL | NULL | |

February 20, 2019 at 1:57 PM igngppTErreg TuaalinsFied l Estineledhedttion l Tutal@ages 1 1 Nedes I108704 1STANDARD IPARC PARQUE l false I1 00704 1 STANDARD ISECT LANAUSSE 100704 ISTANDARD URB EUGENE RICE PR INOT ACCEPTABL.el 1361-8e.22 1 0.381-Q.80.3NA 'UB IWAEugene Rea,PR 1 NULL NLL IPR INOT ACCEPTABLE 1794 I SS22 I 038 487 0J NA lus lygtLaF*iea, PR false NULL NULL NULL NULLI -INOT ACCEPTABLE 117 .6.22 1 0.3* 1-087 10.3 I NA IUS Vila. Del Coe, PRINA-UsS-PR-VILLAS DEL Coqui I false NULL l Halse NULL February 20, 2019 at 1:57 PM igngppTErreg TuaalinsFied l Estineledhedttion l Tutal@ages 1 1 Nedes I108704 1STANDARD IPARC PARQUE l false I1 00704 1 STANDARD ISECT LANAUSSE 100704 ISTANDARD URB EUGENE RICE PR INOT ACCEPTABL.el 1361-8e.22 1 0.381-Q.80.3NA 'UB IWAEugene Rea,PR 1 NULL NLL IPR INOT ACCEPTABLE 1794 I SS22 I 038 487 0J NA lus lygtLaF*iea, PR false NULL NULL NULL NULLI -INOT ACCEPTABLE 117 .6.22 1 0.3* 1-087 10.3 I NA IUS Vila. Del Coe, PRINA-UsS-PR-VILLAS DEL Coqui I false NULL l Halse NULL