view: closed_loans { derived_table: { sql: with closed_loan_data as ( select row_number() over (order by coalesce(closed_loan_close_date, lead_created_date) desc) as rnk, * from `renofidata.analytics_production.prod_borrowers` where closed_loan_id is...