MODE

1
SELECT MODE(product_id) as most_ordered_product
2
FROM orders
3
WHERE order_date >= '2024-01-01';

1
SELECT
2
  category,
3
  MODE(brand) as most_common_brand,
4
  COUNT(*) as total_products
5
FROM products
6
GROUP BY category;

1
SELECT
2
  customer_segment,
3
  MODE(payment_method) as preferred_payment
4
FROM orders o
5
JOIN customers c ON o.customer_id = c.id
6
GROUP BY customer_segment;