The CEO of AdventureWorks Inc. wants to build a data mart to keep track of the sale orders$$ lifecycle.

Specifically, he wants to know how many days in average the orders were moved from ordered status,

to due status, and to shipped status to the customers. Currently, the company uses the total numbers of

product per order to measure the business process. Provide a $4-$steps dimensional model in the SQL

comment section $(1$ points$),$ create a data mart solution in SQL for the dimension model that you

propose $(2$ points$),$ and provide SQL commands to answer the question above $(2$ points$)$