Use the following query to answer the question below it:

SELECT COUNT $(*)$

FROM PatientDim

INNER JOIN $($ SELECT ProviderDim.ProviderKey

FROM ProviderDim $)$

ON PatientDim.PrimaryCareProviderKey $=$ ProviderDim.ProviderKey

What needs to change for this query to run?

CT ONE OF THE FOLLOWING $(2$ PTS$)$

A$.$ The table in the parent query needs to be aliased

B$.$ The column in the parent query's SELECT clause needs to be aliased

C$.$ The column in the subquery's SELECT clause needs to be aliased

D$.$ The subquery needs to be aliased