I have a table with records of buildings and their inspection dates. Some buildings have been inspected multiple times. I want to return each building and the latest inspection date. Not sure if distinct and max are the ways to return each building once and the largest building date. Any help would be appreciated.