MODE

1
SELECT 
2
  MODE() WITHIN GROUP (ORDER BY category) AS most_common_category
3
FROM products;

1
SELECT 
2
  store_id,
3
  MODE() WITHIN GROUP (ORDER BY product_id) AS best_seller
4
FROM sales
5
GROUP BY store_id;

1
SELECT 
2
  product_id,
3
  MODE() WITHIN GROUP (ORDER BY rating) AS typical_rating,
4
  AVG(rating) AS avg_rating
5
FROM reviews
6
GROUP BY product_id;