What are common SQL and transformation tasks you handle with Kettle (job and transformations)?
Use the supplied PostgreSQL tables to demonstrate a representative transformation that joins related data, filters records, calculates order totals, aggregates customer results, handles missing values, and assigns a classification.
Output
- Return one row per customer with
customer_id, customer_name, completed_orders, total_sales, average_order_value, and sales_band.
- Include customers without completed orders, order by
total_sales descending and customer_id ascending.
