Pivot order-status counts

Q: Pivot order-status counts

This question evaluates data transformation and aggregation skills, specifically pivoting relational order data into per-shopper status counts, along with efficient Java implementation and handling of date-parsing constraints without external libraries.

Q: How do I approach Coding & Algorithms interview questions?

Coding & Algorithms questions require understanding of core concepts and practice. PracHub provides solutions with explanations to help you master coding & algorithms interviews.

Question

Question

Given an orders table (order_id, shopper_id, order_date, status, …), pivot the data so that each row is one shopper and each column shows the count of orders for a specific status (e.g., DELIVERED, CANCELED, RETURNED). Provide an efficient Java solution that works on a platform without external date-parsing libraries.

Pivot order-status counts

Question

Comments (0)