SELECT

CASE

WHEN pats.BirthDate $<=$ DATEADD$($ year, $-18,$ CURRENT$\_$TIMESTAMP $)$

THEN 'Adult'

WHEN pats.BirthDate $<=$ DATEADD$($ year, $-1,$ CURRENT$\_$TIMESTAMP $)$

THEN 'Child'

WHEN pats.BirthDate IS NOT NULL

THEN 'Infant'

ELSE 'Missing Birthdate'

END PatientAgeGroup

FROM

PatientDim pats

However, when you try to join to this subquery, shown below, you get an error.

SELECT

Name

$,$PatientAgeGroup

FROM

PatientDim pat

INNER JOIN pat$\_$age

ON pat.PatientKey $=$ pat$\_$age.PatientKey

What is causing the error?

SELECT ONE OF THE FOLLOWING $(3$ PTS$)$

A$.$ The join condition must use "pats" instead of "pat$\_$age"

B$.$ PatientKey is not in the SELECT clause of your subquery

C$.$ The join condition must use "pat" instead of "pat$\_$age"

D$.$ Name is not in the SELECT clause of your subquery