The following tables (Directory and Orders) show sample order information for a store. Create a join to match CustomerName with OrderDate in one table.

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Tableau/Excel

1. The file “High school graduation data” includes data on the number and percentage of students graduating by county and state for Tennessee. Create a visualization using Tableau Public  to show the percentage of students graduating from high school from 2014 - 2018 in Shelby County. If unable to visualize in Tableau, please use Excel. Submit a twbx file or Excel file with your visualization.

SQL

1. The following tables (Directory and Orders) show sample order information for a store. Create a join to match CustomerName with OrderDate in one table.

“Directory”

“Orders”

2. The following table shows data for TN Ready Science Scores in Tennessee. Data represent the number and percentage of students from 3rd to 8th grade who achieved on-track or mastered scores in science in 2018. Write a SQL query to show the number of students scoring on-track or mastered in Anderson County.

 

“TNReady_Science”

LocationType	Location	TimeFrame	DataFormat	Data
State	Tennessee	2018	Number	170718
State	Tennessee	2018	Percent	0.591
County	Anderson	2018	Number	1887
County	Anderson	2018	Percent	0.61775
County	Bedford	2018	Number	1189
County	Bedford	2018	Percent	0.447
County	Benton	2018	Number	451
County	Benton	2018	Percent	0.705
County	Bledsoe	2018	Number	261
County	Bledsoe	2018	Percent	0.525
County	Blount	2018	Number	3683
County	Blount	2018	Percent	0.77314
County	Bradley	2018	Number	2847
County	Bradley	2018	Percent	0.59962

 

Attachments:

Related Questions

. Introgramming & Unix Fall 2018, CRN 44882, Oakland University Homework Assignment 6 - Using Arrays and Functions in C

DescriptionIn this final assignment, the students will demonstrate their ability to apply two ma

. The standard path finding involves finding the (shortest) path from an origin to a destination, typically on a map. This is an

Path finding involves finding a path from A to B. Typically we want the path to have certain properties,such as being the shortest or to avoid going t

. Develop a program to emulate a purchase transaction at a retail store. This program will have two classes, a LineItem class and a Transaction class. The LineItem class will represent an individual

Develop a program to emulate a purchase transaction at a retail store. Thisprogram will have two classes, a LineItem class and a Transaction class. Th

. SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 1 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of

. Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of