Multiple CTEs in One Query

CTEs are a great thing to use in your query. They are an excellent way to consolidate code and make it readable as well as create a “view” inside of your code. One great thing I have used them for many times was to pick out the max date associated ...