Question $1$ ?of $2$

You are analyzing sales at Way Cool Stuff by region for the years $2024$ ?and $2025.$ ?The following database tables are available.

$1)$

What fields will you use to join the tables?

Customer name

Employee number

Item number

Location number

Order number

Region number

Sales order number

Variable marketing

Transcribed Image Text:

Question 1 of 2 < > 0/1 You are analyzing sales at Way Cool Stuff by region for the years 2024 and 2025. The following database tables are available. Locations SalesOrders Employee Location Number LocationDescription SalesOrderNumber OrderNumber EmployeeNumber FirstName Model LastName SoldDate Address SalesVolume City Color Location RegionNumber State ZipCode RegionNumber State Regions Country RegionNumber UnitSalePrice RegionName CustomerNumber EmployeeNumber Inventory Item Number Item Description Color QuantityOnHand SalesOrderExpenses OrderNumber VariableMarketing Labor Materials Overhead TotalWarranty TotalDepreciation SalesTax Customer CustomerNumber CustomerName CustomerAddress CustomerCity CustomerState CustomerZipCode ContactFirstName ContactLastName PhoneNumber Question 1 of 2 < > 0/1 You are analyzing sales at Way Cool Stuff by region for the years 2024 and 2025. The following database tables are available. Locations SalesOrders Employee Location Number LocationDescription SalesOrderNumber OrderNumber EmployeeNumber FirstName Model LastName SoldDate Address SalesVolume City Color Location RegionNumber State ZipCode RegionNumber State Regions Country RegionNumber UnitSalePrice RegionName CustomerNumber EmployeeNumber Inventory Item Number Item Description Color QuantityOnHand SalesOrderExpenses OrderNumber VariableMarketing Labor Materials Overhead TotalWarranty TotalDepreciation SalesTax Customer CustomerNumber CustomerName CustomerAddress CustomerCity CustomerState CustomerZipCode ContactFirstName ContactLastName PhoneNumber