Question: Below is a snapshot of data from two tables: Orders and Customers, taken on 02/05/2016. You the following documentation: The ORDERS table gets updated at

Below is a snapshot of data from two tables: "Orders" and "Customers", taken on 02/05/2016. You the following documentation: The ORDERS table gets updated at the end of every day The CUSTOMERS table gets updated at the end of every week ORDERS Table Field Name Description ORDER_DT Date the order was placed. ORDER_ID A unique identifier for each order. ORDER_STATUS The status of an order. CUSTOMER_ID Identifies a unique customer. CUSTOMERS table Field Name Description CUSTOMER_ID The unique identifier of the Customer trading in the market CUSTOMER_STATUS The Customer's account status. It should be 'Active' in order to be eligible for Order processing. CUSTOMER_FNAME First name of a customer. CUSTOMER_MNAME Middle name of a customer. CUSTOMER_LNAME Last name of a customer. GENDER Gender of a customer. AGE Age of a customer. Table Name: ORDERS ORDER_DT ORDER_ID ORDER_STATUS ORDER_STATUS_CD CUSTOMER_ID 2/1/2016 1000002 Completed S 4 2/2/2016 2000008 Processing P 6 2/2/2016 2000009 Completed S 7 2/2/2016 2000010 Completed S 7 2/3/2016 3000008 Processing P 6 2/3/2016 3000009 Cancelled C 6 2/3/2016 3000010 Cancelled C 4 2/3/2016 3000011 On Hold H 3 2/3/2016 3000012 Processing P 2/4/2016 4000005 Completed S 6 (Continued on next page) Page | 5 FINRA
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
