我试图生成一份只显示65岁及以上客户的报告。我想知道什么是months_between的SQL等价物,以及如何正确地将报告限制在客户端( 65+ )上。我已经把我的声明写在下面。如能提供任何协助,我们将不胜感激。谢谢。
SELECT person.idFamily AS Family_ID, person.id AS Person_ID,(SELECT person.firstName+ ', ' + person.lastName) AS Name, person.Race AS Race, person.Ethnicity as Ethnicity, family.cap