Independent Column Order Reconciliation

A reporting pipeline stores two numeric signals in the same table, but downstream ranking requires each signal to be ordered independently before recombining rows.

Table: Data

• first_col: integer metric A
• second_col: integer metric B
• the table can contain duplicate rows

Task: Produce an output table with the same number of rows as Data such that:

1. first_col is sorted in ascending order.
2. second_col is sorted in descending order.
3. Row i pairs the i-th value from the sorted first_col sequence with the i-th value from the sorted second_col sequence.

Output requirements:

• Return exactly two columns:
  • first_col
  • second_col
• Return exactly the same number of rows as in Data.
• Respect the independent ordering rules exactly.

Supported submission environments:

• SQL (SQLite 3.27.2)
• Pandas (Python)

Data:
| first_col | second_col |
|-----------|------------|
| 4         | 2          |
| 2         | 3          |
| 3         | 1          |
| 1         | 4          |

[
  {"first_col":1,"second_col":4},
  {"first_col":2,"second_col":3},
  {"first_col":3,"second_col":2},
  {"first_col":4,"second_col":1}
]

Data:
| first_col | second_col |
|-----------|------------|
| 5         | 10         |
| 5         | 7          |
| 1         | 7          |
| 3         | 9          |
| 3         | 8          |
| 1         | 10         |

[
  {"first_col":1,"second_col":10},
  {"first_col":1,"second_col":10},
  {"first_col":3,"second_col":9},
  {"first_col":3,"second_col":8},
  {"first_col":5,"second_col":7},
  {"first_col":5,"second_col":7}
]

Data:
[]

[]