Optimize a slow-running SQL query containing multiple subqueries and complex joins on a distributed data warehouse like Snowflake or Redshift.
