Answered step by step
Verified Expert Solution
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 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 PriorCountry, COUNT AS TotalTransfers FROM DriverLicenses WHERE OutOfCountryLicenseTransfer GROUP BY PriorCountry ORDER BY TotalTransfers 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 people from out of the country moved to Washington state and of them moved to King County that would be Other than King, Snohomish and Pierce County, what are the next most popular counties that people from out of the country register for a new license? Which month and year have the most people transferred licensesids 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 people from out of state moved to Washington state and of them moved to King County that would be Other than King, Snohomish and Pierce County, what are the next most popular counties that people from out of state register for a new license? Which month and year have the most people transferred licensesids 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 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 countries identified by your data. Locate the official language of those countries and the countycounties that the brochure should be sent toYou 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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started