SELECT COUNT(*) AS order_count
FROM orders;

SELECT
  COUNT(*) AS order_count,
  SUM(amount) AS total_amount,
  AVG(amount) AS average_amount,
  MIN(amount) AS min_amount,
  MAX(amount) AS max_amount
FROM orders;

SELECT
  customer_id,
  COUNT(*) AS order_count,
  SUM(amount) AS total_amount
FROM orders
GROUP BY customer_id;

SELECT
  order_date,
  status,
  COUNT(*) AS order_count
FROM orders
GROUP BY order_date, status;

SELECT
  customer_id,
  SUM(amount) AS total_amount
FROM orders
GROUP BY customer_id
HAVING SUM(amount) >= 5000;

SELECT
  customer_id,
  SUM(amount) AS total_amount
FROM orders
WHERE status = 'paid'
GROUP BY customer_id
HAVING SUM(amount) >= 5000
ORDER BY total_amount DESC;