Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

TASK:Using your own database created from assignment 5 and create your own sqls , answer the following questions:Out of Country TransfersWhat are the top five

TASK:Using your own database created from assignment 5 and create your own sqls, answer the following questions:Out of Country TransfersWhat are the top five countries that people have moved from? Example: SELECT Prior_Country, COUNT(*) AS Total_Transfers FROM Driver_Licenses WHERE [Out_Of_Country_License_Transfer]='1' GROUP BY Prior_Country ORDER BY Total_Transfers DESC Answer: Canada, Brazil, India, American Samoa, and China What are the top five countries that people moved from to KING County? What are the top five countries that people moved from to Snohomish County? What are the top five countries that people moved from to Pierce County? What percentage of people from out of the country moved to KING County?Example: Let's say 10,000 people from out of the country moved to Washington state and 5,000 of them moved to King County - that would be 50%. Other than King, Snohomish and Pierce County, what are the next 3 most popular counties that people from out of the country register for a new license? Which month and year have the most people transferred licenses/ids from out of the country? the least?Out of State TransfersWhat are the top five states that people have moved from? What are the top five states that people moved from to KING County? What are the top five states that people moved from to Snohomish County? What are the top five states that people moved from to Pierce County? What percentage of people from out of state moved to KING County?Example: Let's say 10,000 people from out of state moved to Washington state and 5,000 of them moved to King County - that would be 50%. Other than King, Snohomish and Pierce County, what are the next 3 most popular counties that people from out of state register for a new license? Which month and year have the most people transferred licenses/ids from out of the state? the least?Business Decisions Using information from your program, answer the following questions. Provide a rationale for your answer. The state of Washington has asked you to provide information on how to reallocate budget for the counties. You are being asked to create a classification system of up to 5 levels that assigns each county by transfer frequency for budget priority. What would that classification system look like? How would you classify each county into each level? Create a list showing the names of the counties and which level they would belong to. The state would like to create a conference for Licensing Agencies to attend. Which two months of the year would be the best to have a conference with the least amount of transfers? The state has some additional marketing budget that they would like to use to create brochures in the official or prominent language of the top 10 countries identified by your data. Locate the official language of those countries and the county/counties that the brochure should be sent to.(You may need to research the official language via the World Fact Book website.)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Next Generation Databases NoSQLand Big Data

Authors: Guy Harrison

1st Edition

1484213300, 978-1484213308

Students also viewed these Databases questions