Find the top 3 highest-balance active accounts for each account type. Use ROW_NUMBER() in a CTE, then filter for the top 3. Return account_type, id, balance, and the row number (rn). Sort by account_type, rn.