Question: 1. You're exploring data in the Customers and Orders tables and you're discovering that there are customers without orders in the last three months. As
1. You're exploring data in the Customers and Orders tables and you're discovering that there are customers without orders in the last three months. As a manager, what's the action you'll take for this fact? 2. You're also discovering that there are orders without associated customers. What's the action you'll take for this fact? 3. Corporate rules state that no two customers can have identical last and first names. What will you do to prevent this issue from happening? 4. Finally, you see that there are some null values in the country field. The country is always USA. What will you do to solve this issue?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
