Example queries against this table

1. Select all orders with NULL shipped_at (not shipped)

   SQLCopy

   SELECT order_id, cust_id, order_date, status
   FROM orders
   WHERE shipped_at IS NULL;

2. Show total revenue from all orders

   SQLCopy

   SELECT
     SUM(total) AS total_revenue,
     COUNT(*) AS order_count,
     ROUND(AVG(total), 2) AS avg_order_value
   FROM orders
   WHERE status = 'completed';

3. Find all orders NOT in pending or cancelled status

   SQLCopy

   SELECT order_id, cust_id, total, status
   FROM orders
   WHERE status NOT IN ('pending', 'cancelled')
   ORDER BY order_date DESC;

4. Find orders placed in the last 30 days

   SQLCopy

   SELECT order_id, cust_id, order_date, total
   FROM orders
   WHERE order_date >= NOW() - INTERVAL '30 days'
   ORDER BY order_date DESC;