need a sql expert
₹100-400 INR / tunti
. 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.
Projektin tunnus: #14439447
Tietoa projektista
33 freelanceria on tarjonnut keskimäärin ₹572/tunti tähän työhön
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ää
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ää
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ää
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
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ää
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.
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.
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.
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.
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)
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ää
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.