A). Removing the Canceled ROWS will keep only Finished: "Only rows with a Status of Finished are used in analysis." D)."Users only use the DATE part of the Sales_Date". We can split date and time columns, it reduces the load times of the query which is a requirement here.