need a sql expert
₹100-400 INR / ώρα
. 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.
Ταυτότητα Εργασίας: #14439447
Σχετικά με την εργασία
33 freelancers κάνουν προσφορά κατά μέσο όρο ₹572/ώρα για αυτή τη δουλειά
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 Περισσότερα
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 Περισσότερα
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 Περισσότερα
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 Περισσότερα
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 Περισσότερα
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.
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 Περισσότερα
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.
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 Περισσότερα
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 Περισσότερα
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.
