MIN

1
SELECT MIN(price) as lowest_price
2
FROM `project.dataset.products`
3
WHERE category = 'Electronics';

1
SELECT
2
  product_category,
3
  MIN(price) as min_price,
4
  MAX(price) as max_price
5
FROM `project.dataset.products`
6
GROUP BY product_category;

1
SELECT
2
  customer_id,
3
  MIN(order_date) as first_order_date,
4
  MAX(order_date) as last_order_date
5
FROM `project.dataset.orders`
6
GROUP BY customer_id
7
LIMIT 5;

1
SELECT
2
  MIN(STRUCT(price, product_name)) as cheapest_product
3
FROM `project.dataset.products`;