need a sql expert

Suljettu Julkaistu 6 vuotta sitten Maksettu toimituksen yhteydessä
Suljettu

. Identify the differences in the population size estimates for each U.S. state the Census Bureau provided in two consecutive years using the most current data and the latest historical data datasets for the national total population in two different SQL tables.

J. 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.

K. 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.

L. 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.

Tietokannan hallinto tekniikka Java MySQL SQL

Projektin tunnus: #14439447

Tietoa projektista

33 ehdotusta Etäprojekti Aktiivinen 6 vuotta sitten

33 freelanceria on tarjonnut keskimäärin ₹572/tunti tähän työhön

vinaysinghh

A proposal has not yet been provided

₹2222 INR / tunti
(47 arvostelua)
5.1
niranjann08

Hi Sir, I went through your project description and I am interested to work on this task. I have 6+ years of experience in software programming and have done several projects as a freelancer. I can provide the best Lisää

₹277 INR / tunti
(16 arvostelua)
4.7
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind o Lisää

₹400 INR / tunti
(15 arvostelua)
4.7
punitpuneet2008

Hello, I have all the skills and experience that makes me a competitive candidate for this post. I have had an ideal prospect and am ready to accept any new challenges that may be put in front of me. If given an opp Lisää

₹504 INR / tunti
(8 arvostelua)
4.7
amoghbhatnagar

Provide the datafile .. or sql and get the screen shot result the cost is accordingly ... recently i have optimize a query from 28 sec to 1.05 sec

₹6111 INR / tunti
(4 arvostelua)
3.2
pramsweety

Dear, Thank you for posting a job on my favorite technology i.e., Microsoft SQL Server. I have been working with Microsoft SQL server for the past 5 years in ERP, Big Data and Data warehousing environment. I have b Lisää

₹666 INR / tunti
(6 arvostelua)
3.0
sgatich

Hi. I'm a programmer from Russia with strong skills in C++. You can see the full list of my skills on my profile page. I have good experience in developing applications using databases and SQL queries. Mostly I worke Lisää

₹400 INR / tunti
(1 arvostelu)
2.9
webdesc

Expert database designer interested to solve your problem. Feel free to discuss further to settle quick deal. Can start working on it immediately. Awaiting your response.

₹500 INR / tunti
(3 arvostelua)
2.1
rebantabm

Hello We can do this with the help of joining functionality and we can easily select data from db . We have some questions 1>Project in custom query? 2>Can you share your data structure? I think their are some t Lisää

₹277 INR / tunti
(1 arvostelu)
0.7
sunilsofteg2006

I am having 10+ years of experience in database development. I have worked with large and complex database queries with very efficiently and effectively. I have 10+ years of proven records in sql.

₹344 INR / tunti
(1 arvostelu)
0.7
dwbabulal

I am 10+ yr experienced sql developer

₹300 INR / tunti
(1 arvostelu)
0.4
utsavvyas16

I am very good at Databased Management system and SQL query. I also build my own indexing mechanism in Database Management System. I can finish your whole project in 2-3 hours.

₹222 INR / tunti
(0 arvostelua)
0.0
ravneetwalia17

A proposal has not yet been provided

₹222 INR / tunti
(0 arvostelua)
0.0
farreedd

A proposal has not yet been provided

₹350 INR / tunti
(0 arvostelua)
0.0
SofTechPEDIA

We've dedicated team of experts to deliver quality solution within your time frame. I can answer your queries on CHAT. Looking forward to work on your project.

₹750 INR / tunti
(0 arvostelua)
0.0
zdesign77

Hey, how is it going today? My name is Michael, I'm a web designer/developer from Boston. I've had a look at your project description and feel that my skills match your requirements perfectly. In fact, I did a very sim Lisää

₹277 INR / tunti
(0 arvostelua)
0.0
indrabasak2003

I am 10 years of experience into Oracle , psql development project. I am Oracle certified associate. Handled lots of projects of SQl. I am also experience data modeling, Oracle BI (OBIEE)

₹333 INR / tunti
(0 arvostelua)
0.0
rajiideepa0209

database management system is beautiful Field. it shows the status of current situation with comparison to any other field. MySQL workbench is widely used tool in this field for database management. I have good profici Lisää

₹275 INR / tunti
(0 arvostelua)
0.0
bhavinnayi281

completed training of SQL and have started SSIS training.

₹500 INR / tunti
(0 arvostelua)
0.0
subbun248

Hey I am a SQL expert and an advanced ETL(Extract Transform Load) developer . I am very well versed with your requirement which we do on daily basis. And provide the support as best in the market.

₹388 INR / tunti
(0 arvostelua)
0.0