This post is a continuation of http://forums.sqlteam.com/t/sql-sub-query-help/10776/5.
Now, as @Ifor mentioned, how can completed_date be greater than created_date (see identifier 000318636873)?
Are the combinations of sn_type and sn_status that you show in your sample data, all combinations we will encounter/should handle?