Sales Data

Instructions

Complete the following steps for querying and cleaning the requested sales data.

Steps

Run the Query

Use the query provided by the finance manager in the query field below to retrieve the sales data for the past five quarters, which includes the most recent quarter covering January, February, and March. Click Execute to run the query.

Clean Sales Data

When the option appears, select Download as CSV$.$ Review the retrieved data, and remove any erroneous values by clearing the individual cells containing them, not entire rows. After clearing a cell, simply leave it empty. Then, provide the resulting data file to the finance department manager by uploading it below.

Note: If there are any errors remaining when you validate your file, youll receive feedback pointing out the rows and columns where the errors are. When referring to column numbers, the numbering starts at zero. Therefore, column $0$ in the feedback refers to the ID column, column $1$ is Order Date, and so on$.$

Use this task as an exercise fbecome familiar with the process of querying and cleaning data. Keep a copy of the retrieved file to use when updating the quarterly business report later in the round.