SQL: Re-engagement List

A beauty retail brand wants to identify high-value customers who are still purchasing but have stopped engaging with email. The goal is to create a re-engagement audience of active customers with total purchase value over 500 in the last 90 days, and no email opens in the last 30 days.