用于计算ID的SQL查询，并在日期范围内的容器上显示0

Im sorry as I know this type of question has been asked a lot, but the posts I am seeing dont seem to fit quite what I am trying to do or make a difference, its a simple solution in that I have one table which stores a type ID and a date saved and then another table with that type ID and the type name. Im sorry as I know this type of question has be