search

JohnBossco / Maintenance-And-Repair-Data-Analyzation

Create a relational database to combine all of the provided data sets into a relational database.
0 stars 0 forks source link

Image-Libary #1

Open JohnBossco opened 3 months ago

JohnBossco commented 3 months ago

Location Store Data:

Code_RekNKKziVp

JohnBossco commented 3 months ago

Location Store: For every county in the United States and export a list of all counties sorted from highest score to lowest score. Generate an algorithm that gives a numerical score (ranging from 0 to 100) based on data and key factors that are specified by the customer.

Customer Specifications: Location with relatively low average wages in the service-providing industry; Location with low tax rates; Location with high median income; Location with high unemployment

Code_5bk5wxJ3hv

Code_DA1iUQ2y8U

JohnBossco commented 3 months ago

County Tax Rate

msedge_BXcvyc0kEI

Exports By State 2012

msedge_n8hHtoZ4go

Median County Income

msedge_YWkvhXyGW2

State Tax Rate

msedge_6fiUZ7k8oM

Unemployment By County

msedge_sT5hdrPBq2

Usa County List

msedge_wy9KKuXpA2

Workforce Wages

msedge_4iYD4bKlN3

JohnBossco commented 3 months ago

SQL Queries

2 a) Find all counties that have a state tax rate lower than 4% and an unemployment rate higher than 6%. Sort them by their Annual Total Wages (for all industries) from highest to lowest.

msedge_ObY8plUdMe

2 b) Find the 10 counties with the highest Annual Total Wages in the Service Providing industry that also have a Coefficient of Variation for Ton-Miles greater than 20 (for the year 2012) and a labor force over 7,500.

msedge_7hIsp2whj3

2 c) Find all counties with an Annual Average Pay under $40,000 and a local tax rate under 3%. Sort them from highest population to lowest.

msedge_bo082BnYZU

2 d) Find the 10 counties with the highest population whose 2012 exports value is over 25 trillion and also have a higher Annual Average Establishment Count in Construction than in Manufacturing.

msedge_HVzXZOPL5K

JohnBossco commented 3 months ago

Relational Database Visualization

msedge_GvDpHxt3w0