$1.(5$ points$)$ You have been asked to integrate two sets of data from two sales agents of the same company into a single source that can be analyzed. The two extracted sets of data can be found in the source $1$ and source $2$ worksheet in Excel. It is a collection of orders, organized by item in each order. Multiple rows can be associated with a single order because you can order multiple items in a single order. The column $$extended price$$ is the actual price paid by a customer. The company distinguishes each customer into three different customer statuses: $$Silver$,$Gold$,$ and $$Platinum$.$ Platinum is the best.

$$ Source $1$: The first data source from agent $1(29$ records$)$

$$ Source $2$: The second data source from agent $2(30$ records$)$

To understand the inconsistencies between the data, open the workbook and look at the Source $1$ and Source $2$ worksheets. You$$ll notice that the data doesn$$t quite match up$.$ Please identify the inconsistencies of the two data sources and propose what you would do before loading the data into the company$$s data warehouse. Please structure your answers according to the following format.