Payments from largest to smallest

Payments from largest to smallest

The station Commandant needs a gateway summary with the largest amounts first, so the biggest payments stand out immediately. In response, the amount field stores the payment amount in kopecks as a number. What to return: - payment_id — the gateway response ID - order_id — the order ID - status — the status from response - amount_rub — the amount in rubles: amount / 100, rounded to 2 decimal places Keep in mind: - return every payment - compare the amount as a number when sorting Sort by amount_rub descending, then by payment_id ascending when amounts are equal.

A ordem das linhas importa

PostgreSQLv16
Entre para enviar

O resultado da sua consulta aparecerá aqui

Focus radio
Paused · SomaFM · Fluid