High-value UPI orders in Q1

Question

The payments team at a marketplace wants to review large UPI transactions from the first quarter of 2026 before running a chargeback audit.

From the `shipment_orders` table, return the `order_id`, `customer_name`, `order_date` and `order_value` for every order that was **paid using UPI**, placed be

Accepted Answer

Step 1: Start from `shipment_orders` and project only the four columns the audit needs — `order_id`, `customer_name`, `order_date`, `order_value`. Step 2: Filter the payment channel with `payment_mode = 'UPI'`. String comparison in Postgres is case-sensitive, so match the stored casing exactly. Step 3: Restrict the date range with `order_date BETWEEN DATE '2026-01-01' AND DATE '2026-03-31'`. `BETWEEN` is inclusive on both ends, which is exactly what the requirement asks for. Step 4: Add the value threshold `order_value > 5000`. Use `>` (not `>=`) so the ₹5000 order is excluded. Step 5: All three predicates are combined with `AND`, so a row must satisfy every condition to be returned.

High-value UPI orders in Q1

More WHERE & Filtering questions

Asked at Razorpay