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

 

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. 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

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme