Refer to the exhibit.

An organization stores sales data in SQL Server. A database administrator creates a view to show the transaction data. The data architect must:
Create a data model that shows the total sales for each salesperson by month

Create an indicator that shows whether the total monthly sales meet or exceed the monthly quota,

which is always $1,200
Which script should the data architect use to meet these requirements?
A:

B:

C:

D: