'{contact}' || 'RANK() OVER (PARTITION BY {status} ORDER BY {contact})'