Chapter 4 Exercise 69

69. Which 2-level ICD10 treatment procedure was most common in January - March?

SELECT Left([VisitProcedureID],2) AS Proc2Level,
Count(VisitProcedures.VisitProcedureID) AS CountOfVisitProcedureID
FROM Visit INNER JOIN VisitProcedures ON Visit.VisitID = VisitProcedures.VisitID
WHERE (((Visit.VisitDate) Between #1/1/2013# And #3/31/2013#))
GROUP BY Left([VisitProcedureID],2)
ORDER BY Count(VisitProcedures.VisitProcedureID) DESC;
(big tie at 111)