using QUALIFY ROW_NUMBER WITH PARTITION BY IN TERADATA

using qualify row_number over partition by in teradata