There are three issues with this query: one results in an $$ambiguous column name$$ error; another causes an $$incorrect syntax$$ error; and the last is a logic problem which will not result in an error but which will cause the query to return undesirable data. Identify these issues. How would you fix them?

SELECT

AcctNo

$,$Count$($distinct Decline$\_$Date$)$ as DeclineCount

FROM

tblAccounts

INNER JOIN

tblDeclines

WHERE

tblAccounts.AcctNo $=$ tblDeclines.AcctNo

GROUP BY

AcctNo