Code reviewMediumcr-g539

Subject Code reviewLevel Mid–Senior~18 minCommon in Networking & APIs · Algorithms & data structures interviewsIndustries Software development

Question

Review this SQL-backed paginator used to export all orders. It loops, bumping OFFSET, until a page comes back empty.

What a strong answer looks like

Separate real bugs from style. Rank issues by severity, point at the root cause rather than the symptom, and suggest a concrete fix — specific and kind.

Learn the concepts

Talk through your review

Code to reviewsql

1-- page N (0-indexed), page size 1002SELECT id, customer_id, total, created_at3FROM orders4WHERE status = 'shipped'5ORDER BY created_at6LIMIT 100 OFFSET :n * 100;

Run or narrate your approach, then ask the coach.