Find Jobs
Hire Freelancers

Data Analysis Project using SQLWORKBENCH - NEED ASAP

$30-250 USD

Igangværende
Slået op cirka 6 år siden

$30-250 USD

Betales ved levering
MUST USE SQL WORKBENCH. Write a code to join the two tables on the year and state fields into one SQL table that identifies the absolute differences (in whole rounded hundreds) in the estimates of 10,000 individuals or more between the two datasets. If the earlier estimates are larger than 10,000, the cells should indicate a negative value. Provide a screenshot of your tested code showing successful execution. Explain how you prepared the data and how the datasets were imported into two SQL tables. Provide a screenshot of the successfully executed SQL code. Export the data from the SQL table into a CSV file, with rows representing the states and columns representing the years that both datasets estimate, that only shows the differences between the datasets (in whole rounded tens of thousands) that exceed 10,000 individuals. Note: In your output CSV file include the name of the state, the year, and the delta value, rounded delta in tens of thousands, e.g., i. If the delta is 10,253, for example, the rounded delta would be 10,000. Make sure you calculate the differences for all the common years, i.e. years for which estimates are present in both files (i.e. for all years in the period 2010-2015). Always remember that you work with two data sets. Must show all work.
Projekt-ID: 16759577

Om projektet

4 forslag
Projekt på afstand
Aktiv 6 år siden

Leder du efter muligheder for at tjene penge?

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme
Bliv betalt for dit arbejde
Oprids dit forslag
Det er gratis at skrive sig op og byde på jobs
4 freelancere byder i gennemsnit $176 USD på dette job
Brug Avatar.
Hi there,I am Miljan,Data Analysis expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agreed deadline. Check out my profile, portfolio, and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Kind regards
$245 USD på 3 dage
4,9 (105 anmeldelser)
7,3
7,3
Brug Avatar.
Hello, I read your whole proposal, and thanks for your post on my good experience. This is very good job for me. So I think I can do this in high quality. My releavant skills are: Data Analytics, Python, R Programming Language, SQL, Web Scraping I want to further discuss with you. I look forward to working together in partnership on your project and into the future. Best Regards.
$155 USD på 3 dage
5,0 (38 anmeldelser)
6,2
6,2
Brug Avatar.
Hi, This is Santhosh from India. I am a Business Management Graduate with Computer Science engineering background who is passionate about Data, Mathematics and Technology. I have worked in many data analytics projects involving SAS, Python, SQL & R. Also I have worked in projects involving Excel (Pivot Table, Macros) and VBA. I believe I have enough expertise in SQL to complete this project as per your requirement. I am sure that you will be 100% satisfied with my work. Please get in touch. Looking forward to hear from you. Thanks & Regards, Santhosh
$150 USD på 2 dage
5,0 (62 anmeldelser)
6,0
6,0

Om klienten

Flag for UNITED STATES
Bolingbrook, United States
5,0
4
Medlem siden apr. 21, 2018

Klientverificering

Andre jobs fra denne klient

Python Web Scraping
$10-30 USD
Tak! Vi har sendt dig en e-mail med et link, så du kan modtage din kredit.
Noget gik galt, da vi forsøgte at sende din mail. Prøv venligst igen.
Registrerede brugere Oprettede jobs i alt
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Indlæser forhåndsvisning
Geolokalisering er tilladt.
Din session er udløbet, og du er blevet logget ud. Log venligst ind igen.