Here I am not getting back any results and am wondering where the error is in my lines. This is what I wrote.
SELECT creditdescription, COUNT(encid) AS encounter_count
FROM creditrating
INNER JOIN customer ON creditrating.creditid = customer.creditid
INNER JOIN encounter ON customer.customerid = encounter.customerid
WHERE encdate IN (2015-07-05,2015-07-12,2015-07-19,2015-07-26)
ORDER BY creditdescription DESC
Am I counting the wrong thing?