Verify subscriptions and analyze orders with SQL/Python

Consider two relational tables described below. For each part, provide SQL queries or pandas code that handle edge cases, ties, and missing values exactly. Schema Sample data subscriptions subscription_id status status_date 2001 inactive 2025-02-11 2001 active 2025-03-05 2001 suspended 2025-04-01 2001 inactive 2025-05-10 2002 active 2025-02-15 2002 active 2025-02-15 2003 active 2025-04-10 2003 inactive 2025-04-08 2004 active 2025-06-01 2004 inactive 2025-06-01 orders…