Query: Using CTE to retain notification rules without targets

Description

By using a Common Table Expression ( with query), it is possible to join on targets without discarding notification rules that don't have any targets.

Query

Tables used in this query:

• aws_codestar_notification_rule

SQL