Query: List all certificates that were registered more than a year ago and have not been deregistered

Description

Pinpoint the specific instances where certificates have been registered for over a year and have not yet been deregistered. This can be useful for maintaining security standards and ensuring outdated certificates are properly managed.

Query

Tables used in this query:

• aws_directory_service_certificate

SQL