#$8$ Use the following query to answer the question below it:

SELECT $*$

FROM HSP$\_$ACCT$\_$CVG$\_$LIST

LEFT OUTER JOIN CLARITY$\_$EPM

ON COVERAGE.PAYOR$\_$ID $=$ CLARITY$\_$EPM.PAYOR$\_$ID

LEFT OUTER JOIN COVERAGE

ON HSP$\_$ACCT$\_$CVG$\_$LIST.COVERAGE$\_$ID $=$ COVERAGE.COVERAGE$\_$ID

Why does this query fail to run?

SELECT ONE OF THE FOLLOWING $(1$ PT$)$

A$.$ Queries do not run if they involve multiple tables and the only item in the SELECT clause is $*$

B$.$ The first join type must be an INNER JOIN to enable the second join

C$.$ The order of the joins is incorrect

D$.$ The join conditions should list the column from the destination table on the left side of the operator