Orders over 3000 ₽

Orders over 3000 ₽

The Kotomarket summary needs purchase events with an order amount greater than 3000 rubles. There is one catch: the old app stores total as a string containing a number, while the other versions store it as a number. What to return: - event_id — the event ID - order_id — the order ID, as a number - total — the order amount in rubles, as a number Keep in mind: - placed orders are events with event_type = 'purchase' - total is stored in payload - include only events where total is greater than 3000 Sort by event_id ascending.

Row order matters

PostgreSQLv16

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid